--Thanks for the reply:
--How can I change the format -
FROM this: 2003-11-04-13.49.19.144609
TO this: 2003-11-04 13:49:19.144609
Thanks all!
-X
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
The DB2 registers for those values are CURRENT DATE, CURRENT TIME, and
CURRENT TIMESTAMP. DB2's version of the DUAL table is SYSIBM.SYSDUMMY1
So, either of these would work:
VALUES CURRENT TIMESTAMP
or
SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
or
SELECT CURRENT TIMESTAMP AS TODAY FROM SYSIBM.SYSDUMMY1
Hope this helps,
Fred
