get the hour and minutes from time stamp

[gidon500]

Hi all

I have data coming with time stamp

i found how to get the date , but could not find how to get the hour

can you help

enclosed in qvw file ,

that contains the data

thanks

gidon

[pgalvezt · Accepted solution]

Hi,

Try this:

timestamp(num(date(makedate(1988,1,1)+(Datedata)/(60*24)))) as time Resident a1;