Skip site navigation (1) Skip section navigation (2)

Re: Datetime stored in bigint

From: dev ss <ssdev938(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Datetime stored in bigint
Date: 2011-07-25 19:56:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Greg Sabino Mullane,

   Thanks for your help in converting the bigint to date format using
function but is there a way to run a SQL query to show all the fields in the

Example as below in database it stores as below

documentid   patientname datetime
Z549909343  Test, Test    634459985818906250
Y225220522  Test1,Test  634469467411401690

I need to run a query to show values as below instead of single values
documentid   patientname date
Z549909343  Test, Test    2011-07-11 16:29:00
Y225220522  Test1,Test   2011-07-22      15:52:00

Please let me know if you need more information.

On Mon, Jul 18, 2011 at 4: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.

In response to


pgsql-novice by date

Next:From: Mathieu DuboisDate: 2011-07-26 07:45:17
Subject: Re: cast bytea to double precision[]
Previous:From: Mathieu DuboisDate: 2011-07-25 15:58:02
Subject: Re: cast bytea to double precision[]

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group