Postgres Pro
Downloads
Home   >   mailing lists

Re: biginteger to timestamp - Mailing list pgsql-admin

From LiveShell
Subject Re: biginteger to timestamp
Date
Msg-id 928fe9b50607200241pea3a0bej11083ebd45dae8d4@mail.gmail.com
Whole thread Raw
In response to Re: biginteger to timestamp  ("hubert depesz lubaczewski" <depesz@gmail.com>)
Responses Re: biginteger to timestamp  ("Ben K." <bkim@coe.tamu.edu>)
Re: biginteger to timestamp  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
Tree view
hi hubert
actally i have UNIX time and that is in 1153222974  format. and i m using C api to insert this time in a column whose type is timestamp.
so now can u tell me .... how can i convert it to timestamp and insert into the timestamp column.

 
On 7/20/06, hubert depesz lubaczewski <depesz@gmail.com> wrote:
On 7/20/06, LiveShell < liveshell@gmail.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

pgsql-admin by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: Re: biginteger to timestamp
Next
From: "Ben K."
Date:
Subject: Re: biginteger to timestamp