RE: [sqr-users] Date Calculations Help

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

I'm not sure about db2, but some databases would allow:

input #days 'How many days'

begin-select
...
from table t
where t.datefield between (sysdate - #days) and sysdate
end-select


-----Original Message-----
From: Deborah Harris [mailto:dharris@activeinterest.com]
Sent: Tuesday, October 21, 2003 4:26 PM
To: 'Sqr-Users Group'
Subject: [sqr-users] Date Calculations Help


Hi Everyone, 

 

I need to do some date calculations based on a value I receive from a
user.   They supply me with a number like 5.    I then need to calculate
5 days back from the current date and then do a selection of records
based on the current date and the new calculated date.     Does anyone
have some sample code on how I can do this?    

 

I am using SQR 8.1 and accessing a db2 database.  

 

Thanks in advance for any help.. 

 

 

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users