Steve - DND wrote:
> >
> > What version of PostgreSQL are you running? I seem to remember a few
> > versions ago the offset having the wrong sign.
>
> I'm running 8.0.2 Win32.
BSD Unix looks strange too:
test=> select current_timestamp;
timestamptz
-------------------------------
2005-04-21 19:45:55.553635-04
(1 row)
test=> SELECT timezone('UTC', current_timestamp::timestamp);
timezone
-------------------------------
2005-04-21 15:46:12.740201-04
(1 row)
test=> SELECT timezone('UTC', current_timestamp::timestamp)::timestamp
without time zone;
timezone
----------------------------
2005-04-21 15:46:14.333257
(1 row)
But these look fine:
test=> SELECT timezone('UTC', current_timestamp);
timezone
---------------------------
2005-04-21 23:48:18.60604
(1 row)
test=> SELECT current_timestamp::timestamp;
timestamp
----------------------------
2005-04-21 19:51:25.867765
(1 row)
test=> SELECT current_timestamp::timestamp with time zone;
timestamptz
-------------------------------
2005-04-21 19:51:30.178186-04
(1 row)
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073