Re: timestamp to int

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.

-Mitch

----- Original Message -----
From: "Edwin Grubbs" <egrubbs(at)rackspace(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, June 26, 2001 11:16 AM
Subject: [GENERAL] timestamp to int

> Is there any function for converting a timestamp into an integer with the
> unix seconds value? It's really easy to convert in the other direction.
>
> -Edwin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>