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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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