Get datetime field value in a specific timezone when using direct sql query with Dynamics

(0) Share

Report

Posted on by AbdiasM

I'm using a direct sql query to fetch datetime fields from Dynamics 365. It returns the datetime values in UTC (as stored in the Sql DB). Is there a way to get the datetime field value in a specific time zone (E.g. EST or JST) when using sql query?

All responses (4)

Answers (0)

Suggested answer

Yoshika Suzuki on at

Like (0)

Report

RE: Get datetime field value in a specific timezone when using direct sql query with Dynamics

SQL is registered in UTC and displayed in the Dynamics 365 UI according to the time zone set by the user.

It may be possible to convert the time in a SQL query.

learn.microsoft.com/.../at-time-zone-transact-sql
Suggested answer

Abdul Wahab 12,070 Super User 2024 Season 1 on at

Like (0)

Report

RE: Get datetime field value in a specific timezone when using direct sql query with Dynamics

Hi AbdiasM,

After reading the instruction I can say No.

...
AbdiasM 5 on at

Like (0)

Report

RE: Get datetime field value in a specific timezone when using direct sql query with Dynamics

Thanks. I'm aware of this solution. I want to know if there's any solution that Microsoft dynamics provides out-of-the-box.
Abdul Wahab 12,070 Super User 2024 Season 1 on at

Like (0)

Report
RE: Get datetime field value in a specific timezone when using direct sql query with Dynamics

Hi AbdiasM,

The below links are going to help you:

https://www.mytecbits.com/microsoft/sql-server/convert-utc-datetime-to-different-time-zones

https://stackoverflow.com/questions/8038744/convert-datetime-column-from-utc-to-local-time-in-select-statement

https://www.w3schools.blog/sql-server-convert-utc-to-pst-sql-command

www.sqlservercentral.com/.../how-can-i-convert-utc-datetime-to-local-est-time