Date weirdness
Gavin M. Roy <gmr@justsportsusa.com>
From: "Gavin M. Roy" <gmr@justsportsusa.com>
To: pgsql-general@postgresql.org
Date: 2002-10-24T20:33:50Z
Lists: pgsql-general
Any ideas why this would happen?
argo.system=# select extract(epoch from date('2002-10-24'));
date_part
------------
1035417600
(1 row)
argo.system=# select date(1035417600);
date
------------
2002-10-23
(1 row)
TIA,
Gavin
---------------------------------------------------------
Scanned by Sophos Anti-Virus v3.59TPOS, MIMEDefang v2.19,
and Spam Assassin v2.31 on satchel.bteg.net