Date weirdness

From: "Gavin M(dot) Roy" <gmr(at)justsportsusa(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Date weirdness
Date: 2002-10-24 20:33:50
Message-ID: 3DB8592E.80804@justsportsusa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-10-24 20:34:08 Re: number of affected rows in pgtcl
Previous Message Ben McMahan 2002-10-24 20:31:57 Turning the PLANNER off