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".
In response to
pgsql-admin by date
|Next:||From: Chris Hoover||Date: 2006-07-21 19:42:15|
|Subject: log entries after pitr recovery|
|Previous:||From: Peter Eisentraut||Date: 2006-07-21 16:42:14|
|Subject: Re: UTF8 characters|