Date weirdness - Mailing list pgsql-general

From Gavin M. Roy
Subject Date weirdness
Date
Msg-id 3DB8592E.80804@justsportsusa.com
Whole thread Raw
Responses Re: Date weirdness  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: number of affected rows in pgtcl
Next
From: Hadley Willan
Date:
Subject: Re: Hot Backup