Forum OpenACS Q&A: Response to date arithmetic

Collapse
3: Response to date arithmetic (response to 1)
Posted by Jonathan Ellis on 03/16/01 05:10 PM
Thanks for the tip!  Interesting, though -- as you say, you can query "WHERE date_created > date_part('epoch','now') + 3600"

but you can't do "WHERE date_created - date_part('epoch','now') > 3600"

It knows how to compare the two, but not how to do arithmetic with them.