DBMS¿¡ µû¸¥ ³¯Â¥Æ÷¸Ë º¯È¯
Oracle - MS SQL - DB2 UDB ÀÇ ¼·Î ´Ù¸¥ ³¯Â¥ Çü½ÄÀ» ¸ÂÃß±âÀ§ÇÑ SQL¹®
DBMS º° ½Ã°£, ³¯Â¥ Á¶È¸ Äõ¸®
Oracle |
select sysdate from dual; ³¯Â¥+½ÃºÐÃÊ ±îÁö Á¶È¸°¡´É
select current_timestamp from dual; ³¯Â¥+¹Ð¸®ÃÊ+½Ã°£Á¸ ±îÁö Á¶È¸ |
MS SQL |
select getdate() ³¯Â¥ + ¹Ð¸®ÃÊ ´ÜÀ§±îÁö Á¶È¸°¡´É
|
DB2 UDB |
select current timestamp from sysibm.sysdummy1 ³¯Â¥+¹Ð¸®ÃʱîÁö Á¶È¸ °¡´É
select current date from sysibm.sysdummy1 ³¯Â¥¸¸ Á¶È¸
select current time from sysibm.sysdummy1 ¹Ð¸®ÃÊ ´ÜÀ§ÀÇ ½Ã°£¸¸ Á¶È¸ | DBMS º° default date format
Oracle |
YY/MM/DD (ÇѱÛ)
DD-MON-YYYY (¿µ¾î) |
MS SQL |
YYY/MM/DD HH:MI:SS (ÇѱÛ)
MM-DD-YYYY HH:MI:SS (¿µ¾î) |
DB2 UDB |
YYYY-MM-DD-HH:MI:SS.MMMMMM (TIMESTAMP ŸÀÔ)
YYYY-MM-DD (DATE ŸÀÔ)
HH:MI:SS.MMMMMM (TIME ŸÀÔ) | ³¯Â¥ Æ÷¸Ë º¯È¯Ç¥
Çü½Ä |
RDBMS |
º¯È¯ ¹®¹ý |
|
Oracle |
TO_CHAR(date_exp, 'YYYY.MM.DD') |
'YYYY.MM.DD' |
MSSQL |
CONVERT(VARCHAR, date_exp, 102) |
|
DB2 |
REPLACE(CHAR(DATE(date_exp),ISO), '-', '.') |
|
Oracle |
TO_CHAR(date_exp, 'HH:MI:SS') |
'HH:MI:SS' |
MSSQL |
CONVERT(VARCHAR, date_exp, 108) |
|
DB2 |
CHAR(TIME(date_exp) , JIS ) |
|
Oracle |
TO_CHAR(date_exp, 'YYYY/MM/DD') |
'YYYY/MM/DD' |
MSSQL |
CONVERT(VARCHAR, date_exp, 111) |
|
DB2 |
REPLACE(CHAR(DATE(date_exp), ISO), '-', '/') |
|
Oracle |
TO_CHAR(date_exp, 'YYYYMMDD') |
'YYYYMMDD' |
MSSQL |
CONVERT(VARCHAR, date_exp, 112) |
|
DB2 |
CHAR(DATE(date_exp)) |
|
Oracle |
TO_CHAR(date_exp, 'HH24:MI:SS') |
'HH24:MI:SS' |
MSSQL |
CONVERT(VARCHAR(8), date_exp, 114) |
|
DB2 |
CHAR(TIME(date_exp) ) |
|
Oracle |
TO_CHAR(date_exp, 'YYYY.MM.DD HH24:MI') |
'YYYY.MM.DD HH24:MI' |
MSSQL |
CONVERT(VARCHAR, date_exp, 102) + ' ' + CONVERT(VARCHAR(5), date_exp, 114) |
|
DB2 |
REPLACE(CHAR(DATE(date_exp), ISO), '-', '.') || CAST( TIME(date_exp) AS CHAR(5)) |
|
Oracle |
TO_CHAR(date_exp, 'YYYY/MM/DD HH24:MI:SS') |
'YYYY/MM/DD HH24:MI:SS' |
MSSQL |
CONVERT(VARCHAR, date_exp, 111) + ' ' + CONVERT(VARCHAR(8), date_exp, 114) |
|
DB2 |
REPLACE(CHAR(DATE(date_exp), ISO), '-', '/') || CAST( TIME(date_exp)) |
|