how to convert float to timestamp in single select query

Поиск
Список
Период
Сортировка
От Maulik Shah
Тема how to convert float to timestamp in single select query
Дата
Msg-id 5518C863.7080901@rosconsultancy.in
обсуждение исходный текст
Ответы Re: how to convert float to timestamp in single select query  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: how to convert float to timestamp in single select query  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Rebecca Zahra
Дата:
Сообщение: Re: GiST indeices on range types
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: how to convert float to timestamp in single select query