any built-in function to get time in seconds? - Mailing list pgsql-general

From zhong ming wu
Subject any built-in function to get time in seconds?
Date
Msg-id i2p9e434c4d1004021741h8ac7f769t63f94e4f027b26a7@mail.gmail.com
Whole thread Raw
Responses Re: any built-in function to get time in seconds?  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: any built-in function to get time in seconds?  (Scott Bailey <artacus@comcast.net>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Kevin Kempter
Date:
Subject: Re: Table space question
Next
From: Adrian Klaver
Date:
Subject: Re: any built-in function to get time in seconds?