tracker issue : CF-3641301

select a category, or use search below
(searches all categories and all time range)
Title:

createdatetime and UTC

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Aaron Shurmer / Aaron Shurmer (Aaron Shurmer)

Created: 09/28/2013

Components: Language

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Normal / Some users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 1

Duplicate ID:	CF-3628953

Related Bugs:
CF-3628953 - Similar to


Problem Description: 

createdatetime doesn't take a time zone. so to create a UTC date time object you need to:
DateConvert( "UTC2local", createDateTime( year, month, day, hour, minute, second ) );

all well and good until you hit daylight savings time and your UTC date values that you are passing to createDateTime are actually for a time that can't possibly exists, such as 2:30am on the day of changeover when clocks go forward from 2am -> 3am. Also, while 'valid' the conversion to UTC time for 2:30am will have 2 possible answers on the reverse clocks backward changover. aka, 2:30am = 2:30am and after the changover, 3:30am = 2:30am due to the createDateTime in local timezone.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3641301

External Customer Info:
External Company:  
External Customer Name: AaronShurmer
External Customer Email:

Attachments:

Comments:

Yeah, this has been made trickier than it ought to have been. -- Adam
Vote by External U.
14428 | September 29, 2013 03:50:40 AM GMT