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.
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.