Re: How do I get the current time in seconds in the unix

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: How do I get the current time in seconds in the unix
Дата
Msg-id 3BCA74CE.EE1433B8@fourpalms.org
обсуждение исходный текст
Ответ на How do I get the current time in seconds in the unix epoch?  (Bill Studenmund <wrstuden@netbsd.org>)
Список pgsql-hackers
> > 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.
> Thomas, I think you broke something.

It was actually a side effect of changing the date/time parser to no
longer ignore unrecognized text fields. The previous behavior has been
there from the Beginning, and the new behavior meant that the search
routine no longer returns "ignore" as a status (which caused the calling
routine to drop into the "special case" tests including "epoch").

Anyway, I've got patches, so no worries...
                      - Thomas


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

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: EXTRACT broken
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: New contrib/tsearch module for 7.2