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