Postgres Pro
Downloads
Home   >   mailing lists

Re: Datetime stored in bigint - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Datetime stored in bigint
Date
Msg-id CAHyXU0xFsKeYk_6xu1r5Nm8a8FtvmwFaAjA-BE21xR927Y3Cyw@mail.gmail.com
Whole thread Raw
In response to Re: Datetime stored in bigint  (dev ss <ssdev938@gmail.com>)
List pgsql-novice
Tree view 
On Mon, Jul 18, 2011 at 3:30 PM, dev ss <ssdev938@gmail.com> wrote:
> Its an EMR  and from the front end i see 7/11/2011 4:29:41 PM and in the
> database i see 634459985818906250.

Well, I think it's the number of nanoseconds after when I was born, so
it can only represent November 11th, 3181, a little after 9AM.

merlin

pgsql-novice by date:

Previous
From: dev ss
Date:
Subject: Re: Datetime stored in bigint
Next
From:
Date:
Subject: Change language settings