rnd=# select extract(epoch from timestamp '2002-09-08 05:29:41');
date_part
------------
1031477381
(1 row)
See the date/time functions documentation.
On Thursday 01 December 2005 04:07 am, Sterpu Victor saith:
> I need a function that will transform from the format '2002-09-08
> 05:29:41' to seconds since 1970.
>
> Thank you.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings