Problem with date on October

People, I have a serious problem with BIRT.

If my query is:
SELECT TO_DATE( '19/10/2009', 'DD/MM/RRRR' ) FROM dual

Birt shows the result as 18/10/2009 23:00:00

This kind of problem occurs only with period 19/10/2009 to 01/11/2009. My database is Oracle, but I tested too in MySQL with Timestamp function and the results was the same.
For the other side, I tested exactly the same query in iReport and it returns correctly date: 19/10/2009 00:00:00.

What's the problem? How can I fix that, please? I'm using BIRT 2.2.1.
Very appreciate.

Find more posts tagged with

Comments

mwilliams

Hi brunocobra,

Is this something you can recreate with the sample database?

brunocobra

No, the problem occurs because of summer time in Brazil.

The way I found is to do a TO_CHAR out of TO_DATE function. With this, it's worked.

mwilliams

Ah, got ya. Glad you found a solution!