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

Re: biginteger to timestamp

From: "Ben K(dot)" <bkim(at)coe(dot)tamu(dot)edu>
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-20 11:41:49
Message-ID: Pine.GSO.4.64.0607200638230.6913@coe.tamu.edu (view raw or flat)
Thread:
Lists: pgsql-admin
> actally i have UNIX time and that is in *1153222974*  format. and i m using

select to_timestamp(1153222974);
http://www.postgresql.org/docs/8.1/static/functions-formatting.html

if you're on 8.1.

HTH.

Ben K.
Developer
http://benix.tamu.edu

In response to

pgsql-admin by date

Next:From: Mr. DanDate: 2006-07-20 18:21:24
Subject: failing archive command
Previous:From: LiveShellDate: 2006-07-20 09:41:35
Subject: Re: biginteger to timestamp

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