Re: Datetime stored in bigint

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: dev ss <ssdev938(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Datetime stored in bigint
Date: 2011-07-18 21:54:32
Message-ID: CAHyXU0xFsKeYk_6xu1r5Nm8a8FtvmwFaAjA-BE21xR927Y3Cyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Jul 18, 2011 at 3:30 PM, dev ss <ssdev938(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message einkauf2 2011-07-19 10:47:55 Change language settings
Previous Message dev ss 2011-07-18 20:30:10 Re: Datetime stored in bigint