tsm:tsm_date
TSM server date and time
TSM> SELECT current timestamp as NOW from sysibm.sysdummy1 NOW --------------------------- 2009-11-01 20:08:25.821297
TSM> SELECT current time as TIME FROM sysibm.sysdummy1 TIME --------- 20:10:45
TSM> SELECT current date as TODAY FROM sysibm.sysdummy1 TODAY ----------- 2009-11-01
TSM> select current timezone as TZ FROM sysibm.sysdummy1 TZ --------- 20000
TSM> select current time - current timezone as NOW_GMT FROM sysibm.sysdummy1 NOW_GMT --------- 19:14:18
TSM> select days (current date) - days (date('1974-02-02')) as days_since_1974 FROM sysibm.sysdummy1 DAYS_SINCE_1974 ---------------- 13056
tsm/tsm_date.txt · Last modified: 2021/01/01 21:25 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
