subtracting n days from java.sql.timestamp

[lukas.habermayr]

Hi all,

I'm trying to substract n days from the current date. I'd like to use this in my query to filter results older than NOW()-n days.
The column in the database is of type timestamp. I guess it's best to do this i the query but I haven't found any working solution yet...
All the other threads are using java.util.date as type.

Any suggestions. 

[darth_fader]

What database environment are you working in? PostgreSQL, SQL Server, MySQL etc?

[darth_fader]

This is fairly straightforward, but if you want to keep it in the query (I strongly recommend that approach, you're on the right track), but it depends on the DB environment you're using. Each flavor of DB has it's own date/time functions for date manipulations

[lukas.habermayr]

It's an specific db environment from a company. The sql language used is SQL-92.
Any other solutions (e.g. using parameters) are ok with me.

Thanks

 

 

[szaharia]

You could use the built-in DATERANGE() function in an expression like this:

DATERANGE("DAY-n").getStart()

where n is the number of days to be substracted.

To make this work, you need to place the jasperreports-functions.jar in your app classpath.