Postgres Pro
Downloads
Home   >   mailing lists

Re: how to add seconds to a TimestampTz - Mailing list pgsql-hackers

From Tom Lane
Subject Re: how to add seconds to a TimestampTz
Date
Msg-id 28866.1173934710@sss.pgh.pa.us
Whole thread Raw
In response to how to add seconds to a TimestampTz  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: how to add seconds to a TimestampTz  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: how to add seconds to a TimestampTz  (Grzegorz Jaskiewicz <gj@pointblue.com.pl>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Is there a better way than going to time_t and back?

Isn't the standard SQL-level locutiontimestamptz + numeric_value * '1 second'::interval
?  I'm not sure what would be the most convenient realization
of this at the C level, but please stay away from time_t ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: how to add seconds to a TimestampTz
Next
From: NikhilS
Date:
Subject: UPDATE using sub selects