On Thu, Jul 20, 2006 at 15:11:35 +0530,
LiveShell <liveshell(at)gmail(dot)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".