Dear Sir/Madam
how to convert float to timestamp in single select query
for exp. i have float as 1.251152515236 ,
i want to convert this to datetime and from datetime to timestamp...
i.e. 02:22:044456
I need sql query
It is actually .crd file made in xml , and i have query inside xml like
<![CDATA[
SELECT USER.LastName, USER.fltime from Tbalname
]>
fltime has float value which i need to convert to time
Regards
Maulik Shah