I’m trying to store the created_at and updated_at values from the /kraken/user API however, SQL Server does not recognize
2011-03-19T15:42:22Z as a valid date/time. What is the format of the date/time values returned by the API? Even when I perform an isDate() function in ColdFusion, the value returns false.
Any questions, please let me know.
Well, I may have asked the question a little too quickly… A simple Google search turned up https://en.wikipedia.org/wiki/ISO_8601 which lead me to use the following SQL to obtain the correct Date/Time.
CAST('2011-03-19T15:42:22Z' AS DATETIME)
The result was
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.