Localized time in workflows?

[calfano]

I'm writing a DQL Block in workflows and I've noticed the times comes back in UTC time. Is there an easy way to localize DQL executions within workflows?

Thank you!

[MichalOlszewski · Accepted solution]

Hi @calfano ,

Seems like thing that DT didn't take into account Timezones in automation.
This is good example for RFE, but for now You can do workaround by conversion to timestamp and adding required Timezone change and converting back to date.

fetch logs
| fields time  = toTimestamp(now()) | limit 1
| fields time_local =  timestampFromUnixSeconds(unixSecondsFromTimestamp(time) + 7200)

Bests
Michal