Time Diffrence in SQL and Navision

minty_friend

Hi Experts, i have a client whose is using navision with SQL Backend

booking is done in Navision from directly navision and website also.

Booking from website is accessing SQL database and making entry into it.

The actual problem is when the booking is done from website, the date and time is accurate in SQL, but when we try to see the date time in Navision it is showing a time gap of around 5 hours...

Can anyone make a guess why this is happening.

geronimo

DateTimes in navision get recalculated in NAV so they have to be stored in sql in GMT as far as i know.

This only happens with datetimes, date and time variables on itself do not have this behavior.

I assume you work at a timezone of GMT + 5 or GMT - 5

kine

Booking from website is accessing SQL database and making entry into it.

I hope that it is only writing into some proprietary table and application server is posting the real things... [-o<

ajayjain

i have the same problem
you can try these

select getdate(), getutcdate()
SELECT DATEADD(minute, DATEDIFF(minute, GETUTCDATE(),GETDATE()), GETutcDATE());