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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
