Very weird date issue.

Question

I have a client that is using CFMX7 Enterprise and an Oracle database. One of the database fields we're pulling in is a date. If the date/time is 04/04/2010 02:xx (2am range), coldfusion is automatically adding an hour to it and making it 03:xx. I changed the time in the field to 1am and 3am and it worked fine with both those numbers and I also left the time at 2am and changed the date to 04/05/2010 and the time remained correct.

Is there some daylight savings time issue from CF7? Anybody have a work around, besides putting in a catch for this specific date and time?

ilssac · Answer

With a version of ColdFusion as old as CF7 you have to be aware that the daylight saving rules in the United States changed since that version was released. If the JVM has not been updated to understand the new rules, then that version is going to be operating on the previous set of day light savings rules.

http://kb2.adobe.com/cps/447/d2ab4470.html

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded