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 по дате отправления: