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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to