This content has been marked as final. Show 2 replies
How do I convert date with numbers like .0000150462962962963 to Time - coming from SAS? In the data set from SAS I set it to time, but it still pulls into Qlikview as a number. I have tried several formats and none are working.
timestamp(Timestamp(Hour, 'HH:MM:SS TT'),'HH:MM ') as time,
Interval(Time(Hour, '0123456789.')/1440, 'h:mm:ss') as NewTime,
Interval(Date(Hour, '0123456789.')/1440, 'h:mm:ss') as NewTime2,
Another example of an hour in decimal is 1.15740740740741E-05
When I run it in SAS Enterprise Guide it is in hh:mm format.