>>>>> "SF" == Stephen Frost <sfr...@snowman.net> writes:
>> (now()::timestamp without time zone - 'epoch'::timestamp without time
>> zone)::reltime::integer
>> (Incidently, is there a better way in 9.4?)
SF> Uh, select extract('epoch' from now()); ?
Thanks. Back when I first needed it (years ago), that long line was the
only recomendation I could find.
SF> The only thing I'd say about this is that you *really* want to use
SF> timestamptz in PG for storing timestamps.
I normally do, but this table hasn't changed in years. Maybe 7.4 or so
was current when it started.
Thanks!
-JimC
--
James Cloos <cl...@jhcloos.com> OpenPGP: 0x997A9F17ED7DAEA6
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
