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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
