Re: biginteger to timestamp - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: biginteger to timestamp
Date
Msg-id 20060721174745.GA3490@wolff.to
Whole thread Raw
In response to Re: biginteger to timestamp  (LiveShell <liveshell@gmail.com>)
List pgsql-admin
On Thu, Jul 20, 2006 at 15:11:35 +0530,
  LiveShell <liveshell@gmail.com> wrote:
> 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.

Note that you should be using "timestamp with time zone" (timestamptz) for
this rather than "timestamp".

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: UTF8 characters
Next
From: "Chris Hoover"
Date:
Subject: log entries after pitr recovery