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