zhong ming wu wrote:
I have been using this one liner c function that I call my_now() to
get the number of seconds since some fixed point in the past. I find
it more convenient than built-in now()
and if I want abstime I do abstime(my_now()). Thing is everytime I
do a major version upgrade I had to recompile this and it's a pain in
the neck. I feel there must be something
built-in with pg to get the same thing since I can get abstime from it
like that.
Well you haven't specified which fixed point in the past. But if you
want to get the number of seconds since the unix epoch use:
extract(epoch from current_timestamp)
Scott
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
