Skip to Content

Datetime string with offset as 'Z' to Datetime Conversion.

Apr 21, 2017 at 09:22 PM


avatar image
Former Member


I am trying to convert a string to Datetime using DateTime(). This string contains value as '2017-01-13Z'. When I try to convert this string to DateTime using conversion function DateTime('2017-01-13Z') it returns NULL value. I know Z represents Zero Offset in UTC.

When I am trying to convert a string contains '2017-01-12T' to Datetime using same method, it converts it to datetime successfully.

Strange is, the conversion returns datetime for one instance but fails for another instance. I am not sure if this is related to some datetime setting.

Please suggest.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers