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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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