Answered
Question about API Call "start_time"
In the API the following is sent for start_time What is the ".119-05-00"
"start_time": "2017-01-24T11:27:48.119-05:00",
0
Comments
Good morning, Tom!
The .119 represents the milliseconds and the -5:00 is the GMT (Greenwich Mean Time) offset.
In the example, you're seeing 11:27:48.119-5:00 representing
hh.mm.ss.msec-{gmt offset].Let me know if you have any other questions!
Thank you Robin, you a real asset to the Call Rail team.
It's my pleasure!
what is the best setup for the column in mysql to pull the start time?
Hello Tomer,
datetime or timestamp should support the ISO 8601 format that CallRail uses for the start_time values
Please sign in to leave a comment.