On Wed, Dec 03, 2003 at 10:49:01AM -0500, Tom Lane wrote:
>
> SELECT 'epoch'::timestamp + '1070430858 seconds'::interval;
>
> because it will produce a timestamp without time zone, thus
> effectively making the epoch be 1970-1-1 midnight local time. But
> of course the correct Unix epoch is 1970-1-1 midnight GMT. So
> correct code is
> SELECT 'epoch'::timestamptz + '1070430858 seconds'::interval;
>
> or you could use
>
> SELECT 'epoch'::timestamptz + 1070430858 * '1 second'::interval;
> which has the advantage that it works without weird concatenation
> pushups when the numeric value is coming from a variable.
Great! I am not attached to any particular way of doing this, just as
long as some clue about converting UNIX timestamps into PostgreSQL
timestamps gets in there :)
Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 cell: +1 415 235 3778