Re: biginteger to timestamp

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: LiveShell <liveshell(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: biginteger to timestamp
Date: 2006-07-20 09:32:45
Message-ID: 9e4684ce0607200232j5db5ddcdp8ba85ee5b212fbfa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 7/20/06, LiveShell <liveshell(at)gmail(dot)com> wrote:
>
> Hi all,
> I want to convert biginteger and integer data type to timestamp
> data type.
> Can any body tell me how to convert??
>

and what is in this biginteger?
is it something like:
20060720113254::bigint
or rather something like "seconds from epoch"?
or something totally different?

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message LiveShell 2006-07-20 09:41:35 Re: biginteger to timestamp
Previous Message Peter Eisentraut 2006-07-20 09:32:30 Re: biginteger to timestamp