Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL and DB2 and Brio

Status
Not open for further replies.

andrdoba

Technical User
Aug 13, 2002
16
GB
I'm writing Brion queries connecting to DB2. Can anyone help me how to select records between current date and 30 days from current date without asking the user what the current date is?
 
SELECT *
FROM YOUR_TABLE
WHERE
COL_DATE_STORE > CURRENT TIMESTAMP - 30 DAY

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top