https://community.dynatrace.com/t5/Open-Q-A/Convert-a-string-metric-dimension-from-SQL-extension-to/m-p/256646#M33875 <P>Yes, thats what I have used and it solved the problem <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 20 Sep 2024 17:04:03 GMT susmita_k 2024-09-20T17:04:03Z https://community.dynatrace.com/t5/Open-Q-A/Convert-a-string-metric-dimension-from-SQL-extension-to/m-p/254621#M33628 <P>I have metric dimension, start_time coming from SQL extension which is a string, format is&nbsp;&nbsp; '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.</P> Tue, 24 Sep 2024 13:58:25 GMT https://community.dynatrace.com/t5/Open-Q-A/Convert-a-string-metric-dimension-from-SQL-extension-to/m-p/254621#M33628 susmita_k 2024-09-24T13:58:25Z https://community.dynatrace.com/t5/Open-Q-A/Convert-a-string-metric-dimension-from-SQL-extension-to/m-p/256155#M33829 <P>Have you tried using the <A href="https://docs.dynatrace.com/docs/shortlink/conversion-and-casting-functions#toTimestamp" target="_self">toTimestamp()</A>&nbsp;DQL function? It should meet your needs.&nbsp;</P> Tue, 17 Sep 2024 19:11:34 GMT https://community.dynatrace.com/t5/Open-Q-A/Convert-a-string-metric-dimension-from-SQL-extension-to/m-p/256155#M33829 DavidRitter 2024-09-17T19:11:34Z https://community.dynatrace.com/t5/Open-Q-A/Convert-a-string-metric-dimension-from-SQL-extension-to/m-p/256646#M33875 <P>Yes, thats what I have used and it solved the problem <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 20 Sep 2024 17:04:03 GMT https://community.dynatrace.com/t5/Open-Q-A/Convert-a-string-metric-dimension-from-SQL-extension-to/m-p/256646#M33875 susmita_k 2024-09-20T17:04:03Z