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@xxxxxxxxx> wrote:
On 7/20/06, LiveShell < liveshell@xxxxxxxxx> 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
