Re: [GENERAL] porting time calcs to PG

2006-12-08 Thread Andrew Sullivan
On Thu, Dec 07, 2006 at 04:44:35PM -0700, [EMAIL PROTECTED] wrote: > fields. The WHERE clause that I use in SQL Server is: > getdate() + ((2100 + 5 + (9*Points)) / 86400) >= DueTime > > Where the numbers are actually parameters passed in to the function. > Other than changine getdate() to now(),

Re: [GENERAL] porting time calcs to PG

2006-12-07 Thread Bricklen Anderson
[EMAIL PROTECTED] wrote: I'm trying to port an MS statement that's a bit involved with timestamps, and I don't see anything in the docs to lead me forward. It's basically a select statement, looking for records with a timestamp within a certain range, where that range is calculated with one of