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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to