how to get starttime in Dynatrace DQL

[nikhilchandra]

Hi

I have endtime (timestamp format) and duration (duration format), i need starttime by redcucing the duration from endtime. I tried below but the output was wrong. Both start and end values are same. can someone help.

| fieldsAdd StartTime = EndTime - durationMillis

[Cameron-Leong]

Hello,

In DQL you can add/subtract timestamps and durations to get a new timestamp (see screenshot). Can you share the full query you are using?