Force the Date format of a parameter

[diesis]

I have a problem whe running a report using the Calendar input for a date parameter.

The date parameter Data_Inizio (2007-05.01) is passed to mysql so that the query gets executed as:

 

Code:

SELECT
...
FROM
...
WHERE fd_Data 
BETWEEN
DATE('Tue May 01 00:00:00 CEST 2007')
AND
DATE('Sun May 06 00:00:00 CEST 2007')
...

 

Naturally this won't work, because mysql need the date in format like yyyy-mm-dd.

 

I've tried to convert the string to this format using:

 

Code:

[code]... WHERE fd_Data BETWEEN DATE(STR_TO_DATE($P{Data_Inizio}, '%a %b %d %T CET %Y')) AND DATE(STR_TO_DATE($P{Data_Fine}, '%a %b %d %T CET %Y'))

 

The problem is that the string CET changes to CEST when Daylight saving changes, and for some monthes it works, and for some other not.

 

Suggestions ?

[diesis]

No one has an idea ? I've searched, byt it seems there a no parameter for the input control.

[dogfuel]

Anyone have and answer to this? Thanks!