Db2/Db2 reference
오늘 날짜 조회하기
@ipajama
2011. 4. 21. 11:59
728x90
$ db2 select current timestamp from sysibm.sysdummy1
1
--------------------------
2011-04-21-11.57.52.025165
1 record(s) selected.
$ db2 values current time
1
--------
15:05:45
1 record(s) selected.
$ db2 values current date
1
----------
10/22/2011
1 record(s) selected.
$ db2 values current timestamp
1
--------------------------
2011-10-22-15.06.48.413881
1 record(s) selected.
728x90