Postgres Pro
Downloads
Home   >   mailing lists

how to convert float to timestamp in single select query - Mailing list pgsql-general

From Maulik Shah
Subject how to convert float to timestamp in single select query
Date
Msg-id 5518C863.7080901@rosconsultancy.in
Whole thread Raw
Responses Re: how to convert float to timestamp in single select query
Re: how to convert float to timestamp in single select query
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rebecca Zahra
Date:
Subject: Re: GiST indeices on range types
Next
From: "David G. Johnston"
Date:
Subject: Re: how to convert float to timestamp in single select query