On Thu, Jul 20, 2006 at 15:11:35 +0530,
LiveShell <[EMAIL PROTECTED]> 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".
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org