Datatype DATETIME

richie · New User Joined: 11 Jun 2005 Posts: 24

Hi,

Please tell me how to use DATETIME datatype in order to extract date part.Please let me know the format to be used in Workign storage to extract date and whether we can use UNSTRING function to seperate Date and time part.

Thanks.

Rameshs · Posted: Thu Oct 27, 2005 4:20 pm

hi,

you can use the db2 function DATE, TIME to extract date, time from timestamp data type.

(e.g)

EXEC SQl
Select date(current timestamp) into :ws-date from sysibm.sysdummy1
END-EXEC