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