Re: How do I get the current time in seconds in the unix - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: How do I get the current time in seconds in the unix
Date
Msg-id 3BCA74CE.EE1433B8@fourpalms.org
Whole thread Raw
In response to How do I get the current time in seconds in the unix epoch?  (Bill Studenmund <wrstuden@netbsd.org>)
List 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 by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: EXTRACT broken
Next
From: Teodor Sigaev
Date:
Subject: Re: New contrib/tsearch module for 7.2