1 year ago

#356137

test-img

user2315182

Google Cloud(Stackdriver): MQL Date Time conversion from UTC to EST

Was hoping if anyone of anyone could assist - basically I am experiencing an issue where DateTime format in my Payload is UTC(Non human-readable format) "2022-03-02T20:48:29.847676541Z". Now the intention is to convert this time format to regular "DD-MM-YYYY hh:mm:ss:ssss" format.

In Metric explorer, I tried using query

metric.Timestamp is in UTC Format "2022-03-02T20:48:29.847676541Z"

fetch cloud_function::logging.googleapis.com/user/metric_name | group_by[metric.IDmetric.Timestamp, string_to_timestamp("metric.Timestamp",'%m/%d/%Y %H:%M:%S:%f')]

But I am getting an error "Expression for time series identifier column 'string_lit_string_to_timestamp' had type 'Date' which is not a valid time series identifier column type"

Was hoping to get some form of assistance, so I can convert UTC Date into a regular date time format.

Regards,

datetime

google-cloud-stackdriver

0 Answers

Your Answer

Accepted video resources