Structure of Date/Time Returned by /kraken/user API

API
1

Hey All,

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.

Thanks,
Blood

2

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

2011-03-19 15:42:22.000