Re: how to convert float to timestamp in single select query

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: how to convert float to timestamp in single select query
Дата
Msg-id CAKFQuwZUwkrFPus_8qiPuPYVBLz=X2C6d=wF2y=3j=mSmJv83g@mail.gmail.com
обсуждение исходный текст
Ответ на how to convert float to timestamp in single select query  (Maulik Shah <mauliks@rosconsultancy.in>)
Список pgsql-general
Дерево обсуждения
On Sun, Mar 29, 2015 at 8:52 PM, Maulik Shah <mauliks@rosconsultancy.in> wrote:
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

​You imply that (float) 1.251152515236 is equal to (time) 02:22:044456​

I have no clue what formula:  f(x) = ?x? would satisfy f(1.251152515236) = '02:22:044456'::time

Once you answer that you can either inline said formula or create a user-defined function to encapsulate it.  See the documentation for the how.

David J.

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

Предыдущее
От: Maulik Shah
Дата:
Сообщение: how to convert float to timestamp in single select query
Следующее
От: Alexey Bashtanov
Дата:
Сообщение: How to diagnose max_locks_per_transaction is about to be exhausted?