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
