mssql :select CONVERT(CHAR(8),getdate(),112)+REPLACE(CONVERT(CHAR(8),getdate(),108),':','') mysql :select convert(date_format(now(),'%Y%m%d%H%i'),char(12)); oracle :select to_char(sysdate, 'yyyymmddhh24mi') from dual;
[Database] Oracle, Mssql, Mysql 현재시간
2011. 6. 2. 22:12