How to get the value of system date in db2 ?

senthilssg · New User Joined: 09 Dec 2005 Posts: 64 Location: USA

Hi All ,

Actually i want to update the one column of a table which has DATE data type with value of system date . For that i need the value for system date .

can any one tell me , In db2 , what is the query is used for getting the value for system date (In oracle sysdate is used for getting the system date ) .

Thanks and Regards ,
Senthil

thanooz · New User Joined: 28 Jun 2005 Posts: 99

senthilssg,

SELECT CURRENT_DATE FROM SYSIBM.SYSDUMMY1;

thak's
thanooz