EPOCH TIMESTAMP Conversion Problem

Поиск
Список
Период
Сортировка
От Amitanand Chikorde
Тема EPOCH TIMESTAMP Conversion Problem
Дата
Msg-id 7e7750290711070237x7da14616i383ace7f513f0882@mail.gmail.com
обсуждение исходный текст
Ответы Re: EPOCH TIMESTAMP Conversion Problem
Список pgsql-sql
hi all,
   I have a table 'myTable'.   There is an attribute  in the table as,


Column      |            Type             | Modifiers
-----------------+-----------------------------+-----------mydate     | timestamp without time zone | not null


I want to convert MAX(mydate) from myTable to Epoch.


SELECT EXTRACT(EPOCH FROM TIMESTAMP WITHOUT TIME ZONE '2007-11-01
17:42:01.81693') ::int4;


How the above query can be used to convert MAX(mydate) to EPoch value?
Is there any other query that I can use?
I think it is not worth to write a function/procedure to just replace
the value in a query?
    Please HELP...................

Thanks in advance


-- 
Amitanand N. Chikorde.
Software Engineer
==================================
cat /dev/zero >/dev/null
==================================


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

Предыдущее
От: Keith Carr
Дата:
Сообщение: Bitemporal - problem with correalated subquery?
Следующее
От: "Philippe Lang"
Дата:
Сообщение: Temporal databases