cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Convert a string metric dimension from SQL extension to timestamp

susmita_k
Guide

I have metric dimension, start_time coming from SQL extension which is a string, format is   'mm/dd/yyyy hh24:mi:ss'. I need to convert it to timestamp and then get the duration from the current time to identify if the job is running long. Could anyone please help how can I convert this string to timestamp ? Thanks in advance.

2 REPLIES 2

DavidRitter
Dynatrace Helper
Dynatrace Helper

Have you tried using the toTimestamp() DQL function? It should meet your needs. 

Yes, thats what I have used and it solved the problem 🙂

Featured Posts