Re: [GENERAL] change in now() and ago with 7.x

2000-07-06 Thread Thomas Lockhart
> Pre-7.x, we used to use a line like: " request.date_submitted > (now() > + '24 hours ago')" > to pull data created in the past day (used against a timestamp). > Something changed with 7.x that blows that line out. You will have to be more specific on what is not working for you. afaict that l

[GENERAL] change in now() and ago with 7.x

2000-07-06 Thread David Stokes
Pre-7.x, we used to use a line like: " request.date_submitted > (now() + '24 hours ago')" to pull data created in the past day (used against a timestamp). Something changed with 7.x that blows that line out. I am looking for a work around for use with 7.x. Currently I'm using "select now()::DA