current date,time

[amar]

can n e 1 plz tell me , how to take current date and current time in db2 queries

also how to autogenerate ...............

[ovreddy]

---------+---------+---------+---------+---------+---------
SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1;
---------+---------+---------+---------+---------+---------

---------+---------+---------+---------+---------+---------
10/07/2006
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------
SELECT CURRENT TIME FROM SYSIBM.SYSDUMMY1;
---------+---------+---------+---------+---------+---------

---------+---------+---------+---------+---------+---------
07.12.29
DSNE610I NUMBER OF ROWS DISPLAYED IS 1

[ambilileela]

Hi

To add to it you can get the current timestamp by giving

SELECT CURRENT TIMESTAMP
FROM SYSIBM.SYSDUMMY1


********************************* Top of Data ***************
---------+---------+---------+---------+---------+---------+-
SELECT CURRENT TIMESTAMP
FROM SYSIBM.SYSDUMMY1
---------+---------+---------+---------+---------+---------+-

---------+---------+---------+---------+---------+---------+-
2006-10-24-01.24.48.381162
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100


Thanks,
Ambili