Navision and SQL Display Different

jubeljoy

I have facing one issue with Navision front end shows one record say time as 3:00 but SQL table shows time as 22:00. Anybody having idea what was the route cause for this?

krzychub83

NAV is showing time based on your Windows localization setup (according to your Time Zone), while it saves it into the SQL as UTC time. Thus you see difference between them.

jubeljoy

Thanks