Home > mailing lists

Datetime stored in bigint - Mailing list pgsql-novice

From	dev ss
Subject	Datetime stored in bigint
Date	July 15, 2011 19:59:17
Msg-id	CAKYg8QR24yvF+PvuuffCWYEh-ZfzCt+k+NvVb3qmg8E2dN756Q@mail.gmail.com Whole thread Raw
Responses	Re: Datetime stored in bigint ("Greg Sabino Mullane" <greg@turnstep.com>)
List	pgsql-novice

Hi,

We have a program store into postgres database as UTF-8 format i need to convert this value from 634301616478281250 to date time format.

Any help is greatly appreciated.

Thanks,

Sam.

From: Thom Brown
Date: 13 July 2011, 10:00:47
Subject: Re: Compare rows

From: "Greg Sabino Mullane"
Date: 15 July 2011, 21:13:13
Subject: Re: Datetime stored in bigint