Re: definative way to place secs from epoc into timestamp

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Bret Hughes <bhughes(at)elevating(dot)com>
Cc: postgresql sql list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: definative way to place secs from epoc into timestamp
Date: 2005-03-03 06:41:00
Message-ID: 2bf00b6e6300e2c76bc3c09fa89e7913@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Mar 3, 2005, at 14:42, Bret Hughes wrote:

> also my first two pgsql functions :)
>
> cat ts2int.sql

FWIW, there's a patch in the queue for 8.1 that adds a to_timestamp
function that converts between Unix epoch and timestamp with time zone.

http://momjian.postgresql.org/cgi-bin/pgpatches2

Doesn't help you now, but it'll be there in the future.

Michael Glaesemann
grzm myrealbox com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Smit 2005-03-03 07:19:49 how to monitor the archiving process?
Previous Message Tom Lane 2005-03-03 06:25:02 Re: definative way to place secs from epoc into timestamp