Re: [OpenBD] A "y2k" type of bug?

['Alan Holden' via Open BlueDragon]

This almost looks like a Java bug I saw years ago. I think you can track it down to the validation applied here during native date creation: <cfset cfdate = createDateTime(2017,3,12,2,22,23) /> "Invalid argument. Check the values provided are in the correct range. (java.lang.IllegalArgumentException: HOUR_OF_DAY: 2 -> 3)" I think that validation might be behind subsequent messages like: <cfset newDate = dateAdd("h",0,cfDate)  /> "Data not supported: Invalid date/time string: 2017-03-12 02:22:23" Al Add'l Resources http://stackoverflow.com/questions/22363418/java-simpledateformat-parse-error-due-to-dst https://www.bennadel.com/blog/811-converting-iso-date-time-to-coldfusion-date-time.htm http://www-01.ibm.com/support/docview.wss?uid=swg21250503 https://en.wikipedia.org/wiki/ISO_8601 https://libraries.io/github/AlumnIQ/momentcfc On 3/13/2017 12:25 PM, Ernest McCloskey wrote: I would agree.  But this is a time given to me via Amazon SQS service.  So when I decode it to local time should openBD not realize that this time is part of dst and correct for it? On 3/13/2017 1:17 PM, 'Alan Holden' via Open BlueDragon wrote: I don't know if this is your problem or not... But from a purely real-world point of view - if your region respects daylight savings time - then 3/12/2017 at 2:22am does not exist at all. I think the rule is: at 2:00 AM on Sunday 3-12, the time automatically becomes 3:00 AM In this case, 2:22 am could simply not happen? Al Holden On 3/13/2017 12:18 AM, Ernest McCloskey wrote: Maybe I need to update, but someone please run this and tell me if it crashes for you to? <br /> <br /> Raw Info<br /> <br /> <cfset ISO8601dateString = "2017-03-12T02:22:23.618Z" /> <cfset rawDatetime = left(ISO8601dateString,10) & " " & mid(ISO8601dateString,12,12) /> <cfdump var="#rawDatetime#" /> <cfset newDate = dateAdd("h",0,CreateODBCDateTime(rawDatetime)) > <cfdump var="#newDate#" /> Apparently, 3/12/2017 at 2:22am does not exist in openbd? -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.