When i am getting data by SQL query from Nav16 database, i am getting incorrect time in date-time field. sample attached.Please help to solve the issue.
Thanks in Advance,
This is likely due to the fact that NAV will save the time in UTC format, and convert them according to your regional settings.
Hi,Yes, this is due to the timezone on the database server and regional settings on NAV server.
You can change the time zone from UTC to Server time Zone if you need.