Value of Date in sql query management different from value of date in ax table.(Filtering for the same recid on table and Sql query management ax2012)

(0) Share

Report

Posted on by PaulaRystemi6

150

Hello all,

I am facing a strange problem.

When i filter a table record with the same rec id, on table is shows this record: for the recid = 5637320272 the field svp_dtUscita = 16/09/2021 12:53:11

When i connect to SQL server management and i create a query , on the same environment database, with the same recid 5637320272 on this table, it shows the time 10:53:11.

Does this happens because of different time zones? the table takes value from an external system.

Why the value of time in sql query is different from the table? I am working on ax2012

Thank you in advance

All responses (6)

Answers (2)

PaulaRystemi6 150 on at

Like (0)

Report

RE: Value of Date in sql query management different from value of date in ax table.(Filtering for the same recid on table and Sql query management ax2012)

you're the best :)
Verified answer

Martin Dráb 230,198 Most Valuable Professional on at

Like (1)

Report

RE: Value of Date in sql query management different from value of date in ax table.(Filtering for the same recid on table and Sql query management ax2012)

Do you mean seeing all values in that way? If so, change the preferred timezone to (GMT) Coordinated Universal Time.

If you want to change the behavior just of an individual form control, you can set its Timezone preference property to NoConversion.
PaulaRystemi6 150 on at

Like (0)

Report

RE: Value of Date in sql query management different from value of date in ax table.(Filtering for the same recid on table and Sql query management ax2012)

Hi Martin,

Thanks again,

And if i want the value of time and date, to be same as sql server ? what should i change?

thanks :)
Verified answer

Martin Dráb 230,198 Most Valuable Professional on at

Like (1)

Report

RE: Value of Date in sql query management different from value of date in ax table.(Filtering for the same recid on table and Sql query management ax2012)

There is summer time in Vienna and Amsterdam on 16th September, therefore the actual timezone is CEST (UTC+2), not CET (UTC+1).
PaulaRystemi6 150 on at

Like (0)

Report

RE: Value of Date in sql query management different from value of date in ax table.(Filtering for the same recid on table and Sql query management ax2012)

Hi Martin,

Thanks for the answer.

The users preferred time zone is GMT(+1,Viena,Amsterdam..etc). Why is this difference of 2 hours? Maybe is the fault of the external system that this table takes value?
Suggested answer

Martin Dráb 230,198 Most Valuable Professional on at

Like (1)

Report

RE: Value of Date in sql query management different from value of date in ax table.(Filtering for the same recid on table and Sql query management ax2012)

Date time values in database are in UTC, while value in GUI are displayed (typically) in user's preferred time zone.