[Database] Oracle, Mssql, Mysql 현재시간

ETC

[Database] Oracle, Mssql, Mysql 현재시간

Hoonim 2011. 6. 2. 22:12

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;