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 [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100    cell: +1 415 235 3778

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to