timestamp format varies from webhook event data to REST API data

[Harish]

Hi, 

Here is the data from Webhook and rest api. I'm able to convert webhook timestamp in SQL (Datetimeoffset(7)) but not the rest api one. 

Webhook:

"updated": "2018-07-27T15:05:01.514-07:00",

REST API:

"updated": "2018-05-15T13:11:38.000-0700", [missing : (colon) from above ]

Is there a way to specify the format while querying from REST API ?

Thanks