Coldfusion MX and Daylight Savings
Posted on 2008-06-23
I am running Coldfusion MX 7.0.2 on a fully patched Windows 2003 server. I am running Java Version
1.4.2_11-b06 on the server. I am querying data from an Oracle database. If I view the Oracle data in something like Access the times are displayed correctly because Office doesn't account for DST. Basically I have a value that is read every hour so each day has 24 readings. My problem is that readings between November 4, 2007 and March 9, 2008 all are offset by 1 hour which messes up my data. I've installed al the DST patches for Java and Coldfusion but it doesn't seem to help. I also tried using <cfif> statements to evaluate the dates like <cfif newdate GT 11042007 LT 03092008> but no matter how I format or convert the dates it will not evaluate them and this portion of my code is basically skipped. What I need is actually simple. I want Coldfusion to completely ignore DST. I just want it to read the database and return exactly what is there with no conversion but even if I do a to_char it still apparently applies DST before the conversion. How can I disable DST changes altogether or is there something else I can do to fix this problem?
To get my data I am using the following SQL statement.
WHERE read_time BETWEEN TO_DATE ('#readtime# 00', 'yyyy/mm/dd hh24') AND TO_DATE ('#readtime# 23', 'yyyy/mm/dd hh24')
This gives me the correct data for today for example but anything in the range I listed above is off by an hour.