Invalid format for date

0

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

asked 2 years ago155 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions