Skip to Content
0
Former Member
Dec 09, 2011 at 01:51 PM

Problem with time stamp conversion

726 Views

Hi All,

I am using the below code to convert timestamp to date and time , its working fine when i print it with write statement .

But i want to convert and pass the time and date with format to excel sheet , but its it taking again as string not in date time format .

please see the below code .

time_stamp = 20030309043000.

CONVERT TIME STAMP time_stamp TIME ZONE tz

INTO DATE dat TIME tim.

*WRITE: /(10) dat, (8) tim .

please suggest .