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