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

Datetime stored in bigint

From: dev ss <ssdev938(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Datetime stored in bigint
Date: 2011-07-15 19:58:09
Message-ID: CAKYg8QR24yvF+PvuuffCWYEh-ZfzCt+k+NvVb3qmg8E2dN756Q@mail.gmail.com (view raw or flat)
Thread:
Lists: 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.

Responses

pgsql-novice by date

Next:From: Greg Sabino MullaneDate: 2011-07-15 21:13:05
Subject: Re: Datetime stored in bigint
Previous:From: Thom BrownDate: 2011-07-13 10:00:05
Subject: Re: Compare rows

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