How do I get the current time in seconds in the unix epoch?

Поиск
Список
Период
Сортировка
От Bill Studenmund
Тема How do I get the current time in seconds in the unix epoch?
Дата
Msg-id Pine.NEB.4.33.0110110910290.15927-100000@vespasia.home-net.internetconnect.net
обсуждение исходный текст
Ответы Re: How do I get the current time in seconds in the unix epoch?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How do I get the current time in seconds in the unix epoch?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
I have a function in PL/pgSQL which needs the current time in seconds
expressed as an int4. In 7.1 I was able to get this (I thought) with
date_part(''epoch'', timestamp ''now'') . That doesn't seem to work for me
in last week's -current.

Here's the PLpgSQL:
       v_seed := date_part(''epoch'', timestamp ''now'');

And here's the output:

NOTICE:  Error occurred while executing PL/pgSQL function
NOTICE:  line 4 at assignment
ERROR:  Timestamp with time zone units 'epoch' not recognized

What's the best way to do this?

Take care,

Bill



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: HISTORY
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG: text(varchar) truncates at 31 bytes