porting time calcs to PG

From: greg(at)bryantrecording(dot)com
To:
Cc: recipient list not shown: ;
Subject: porting time calcs to PG
Date: 2006-12-07 23:44:35
Message-ID: 20061207164435.9e7bc6c5a28434177d7b431073d619b9.3aae6248a6.wbe@email.secureserver.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 the
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(), I'm not sure how to change the
+ interval to be effective. All the docs I see use something like
interval '1 hour' - not sure how to put a calculated value in the
quotes. Is this possible?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-12-07 23:51:40 Re: Online index builds
Previous Message Jeff Davis 2006-12-07 23:34:16 Re: Online index builds