Postgres Pro
Downloads
Home   >   mailing lists

Calculation Error on Epoch? - Mailing list pgsql-sql

From Josh Berkus
Subject Calculation Error on Epoch?
Date
Msg-id web-1626380@davinci.ethosmedia.com
Whole thread Raw
Responses Re: Calculation Error on Epoch?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Re: Calculation Error on Epoch?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Calculation Error on Epoch?