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: (view raw, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group