Skip site navigation (1) Skip section navigation (2)

Re: biginteger to timestamp

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: LiveShell <liveshell(at)gmail(dot)com>
Cc: hubert depesz lubaczewski <depesz(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: biginteger to timestamp
Date: 2006-07-21 17:47:45
Message-ID: 20060721174745.GA3490@wolff.to (view raw or flat)
Thread:
Lists: pgsql-admin
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 HooverDate: 2006-07-21 19:42:15
Subject: log entries after pitr recovery
Previous:From: Peter EisentrautDate: 2006-07-21 16:42:14
Subject: Re: UTF8 characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group