how to convert float to timestamp in single select query

From: Maulik Shah <mauliks(at)rosconsultancy(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: how to convert float to timestamp in single select query
Date: 2015-03-30 03:52:03
Message-ID: 5518C863.7080901@rosconsultancy.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bankim Bhavsar 2015-03-30 04:57:31 Re: Index corruption
Previous Message Adrian Klaver 2015-03-29 14:18:54 Re: pgadmin3 installation on Oracle Linux 6.6 64-bit ?