I can't recall why I started using abstime... I started it with some other projects years ago and was under the impression that it was the preferred way. Maybe it was then, but isn't anymore? Maybe I'm just wrong? Anyway, extract() works great, so I'll use that from now on. Thanks!
On Mar 26, 2005, at 12:41 PM, Michael Fuhr wrote:
On Sat, Mar 26, 2005 at 12:22:51PM -0800, Ben wrote:
Is there a workaround I could use, or should I stick with 7.4 for now?
The documentation discourages using abstime -- is there a reason you're using it instead of extract(epoch from now())? That should work in the query.
Is there a reason you're using integer instead of timestamp or timestamp with time zone?
-- Michael Fuhr http://www.fuhr.org/~mfuhr/
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org