파란크리스마스

출처 http://www.w3schools.com/sql/sql_between.asp select decode(statusid,1,1,0) as f1, decode(statusid,2,1,0) as f2, decode(statusid,3,1,0) as f3, decode(statusid,4,1,0) as f4 from jsp_board where write_date BETWEEN to_date(to_char(sysdate,'yyyymmdd') || '000000','yyyymmddhh24miss') and to_date(to_char(sysdate + 1,'yyyymmdd') || '000000','yyyymmddhh24miss')

출처 http://database.sarang.net/?inc=read&aid=27503&criteria=oracle&subcrit=&id=&limit=20&keyword=to_time&page=1 select to_date('20080201000000','yyyymmddhh24miss') from dual

-- 현재 시간보다 30분 전 시간 구하기 ksmsdb=> select now(), now() - interval'30 minute'; now | ?column? -------------------------------+------------------------------- 2007-11-21 10:29:21.635014+09 | 2007-11-21 09:59:21.635014+09 (1 row) -- 현재 시간보다 하루 전 날짜 구하기 ksmsdb=> select now(), now()::date - '1 day'::interval; now | ?column? -------------------------------+--------------------- 2007-11-21 10:32:06.62971..

수동으로 MySQL 설치하는 방법입니다. http://www.mysql.org/downloads/mysql/5.0.html#win32 실행 cd C:\mysql-5.0.37-win32\bin C:\mysql-5.0.37-win32\bin>mysqld.exe 설치 확인 cd C:\mysql-5.0.37-win32\bin C:\mysql-5.0.37-win32\bin>mysqladmin version mysqladmin Ver 8.41 Distrib 5.0.37, for Win32 on ia32 Copyright (C) 2000-2006 MySQL AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are wel..

Install 1. Registry 등록 (HKLM\Software\Firebird Project\Firebird Server\Instances) C:\Firebird\bin>instreg.exe install Firebird has been successfully installed in the registry. 2. NT 서비스 등록 C:\Firebird\bin>instsvc.exe install Service "Firebird Server - DefaultInstance" successfully created. ※ CS(Classic Server) 인 경우 C:\Firebird\bin>instsvc.exe install -classic Service "Firebird Server - DefaultIn..

참고 사이트 http://www.hqunix.com/wp/?p=266 http://blog.naver.com/ladom/60026225972 http://www.linux.com/guides/solrhe/Securing-Optimizing-Linux-RH-Edition-v1.3/chap27sec224.shtml 사용자 만들기 C:\Documents and Settings\bluesanta>net user postgres 1234 /add 명령을 잘 실행했습니다. postgres 사용자로 cmd 실행하기 C:\Documents and Settings\bluesanta>runas /user:postgres cmd postgres의 암호 입력: cmd을(를) 사용자 "SHRYU\postgres"(으)로 시작하..