Re: timestamp to int - Mailing list pgsql-general

From Tomas Berndtsson
Subject Re: timestamp to int
Date
Msg-id 80ithjoxla.fsf@junk.nocrew.org
Whole thread Raw
In response to Re: timestamp to int  ("Mitch Vincent" <mvincent@cablespeed.com>)
Responses Re: timestamp to int  (will trillich <will@serensoft.com>)
List pgsql-general
"Mitch Vincent" <mvincent@cablespeed.com> writes:

> SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
>
> -- and you can replace the timestamp string with the name of a timestamp
> column.
>
> The above is in the manual, BTW.

Is there a way to do it the other way around, from an integer to a
timestamp?


Tomas

pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: Returning records from function
Next
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL: YMMV?