Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Cassandra Trontoski / Cassandra Trontoski (Cassandra Trontoski)
Created: 11/04/2013
Components: Database
Versions: 10.0
Failure Type:
Found In Build/Fixed In Build: Final /
Priority/Frequency: Major / Some users will encounter
Locale/System: English / Win All
Vote Count: 0
Problem Description: Bug ID 3347145 has been closed and marked as fixed despite the fact that several people including myself pointed out that while the fix is no longer converting the UTC value back to local time, it does not properly handle crossing daylight savings boundaries -- e.g. if the system is currently in daylight savings and a date which falls in standard time is stored, the value that is put in the database is altered from the value you intended to store and is off by an hour.
Steps to Reproduce:
Set your system to a timezone which has Daylight Savings rules (e.g. e.g. Pacific/Auckland or US/Eastern).
Execute ScribblesDST.cfm from the zip file provided.
Expected Result:
The values retrieved from the database should match the parameter values that were put into the database.
Actual Results:
The date value which is is outside the current daylight savings setting is off by an hour, exhibiting the current offset rather than the one which should be in effect, even though the value being stored was demonstrated to be correct.
Included in the zip file are the results of the script running under both CF8 and CF10. CF8 stores the value as expected. The CF10 output includes debugging output which shows that the parameter value passed in through the CFPARAM tag has been altered from the desired value.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3658224
External Customer Info:
External Company:
External Customer Name: ctrontoski
External Customer Email:
External Test Config:Attachments:
- November 05, 2013 00:00:00: 1_ScribblesDST.zip
Comments: