Calculation Error on Epoch?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Calculation Error on Epoch?
Date: 2002-08-28 03:30:32
Message-ID: web-1626380@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Folks,

I'm having a problem with:

SELECT date_part('epoch','2002-08-28'::TIMESTAMP)

Which is consistently returning an epoch timestamp that evaluates to
8.27.2002. Is this a known issue? A cross-platform problem?
Suggestions?

-Josh Berkus

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-08-28 03:54:44 Re: Calculation Error on Epoch?
Previous Message Bruce Momjian 2002-08-28 02:45:24 Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?