This is the query I use in the view to put the string to date:
"date_parse"("ctr"."currentagentsnapshot"."agentstatus"."starttimestamp", '%Y-%m-%dT%H:%i:%sZ') "StartTimestamp"
starttimestamp=2022-04-05T01:03:08.234Z
I am getting the below error. Can anyone help, I am guessing there is an issue with '%sZ':
INVALID_FUNCTION_ARGUMENT: Invalid format: "2022-04-04T23:04:59.001Z" is malformed at ".001Z"
This query ran against the "connect_metrics" database, unless qualified by the query. Please post the error message on our forum
or contact customer support with Query Id: b4920385-1417-40aa-b788-ae7e9432cbd7
Thanks
John
