Options

Time Diffrence in SQL and Navision

minty_friendminty_friend Member Posts: 38
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.

Comments

  • Options
    geronimogeronimo Member Posts: 90
    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
  • Options
    kinekine Member Posts: 12,562
    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<
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    ajayjainajayjain Member Posts: 119
    i have the same problem
    you can try these

    select getdate(), getutcdate()
    SELECT DATEADD(minute, DATEDIFF(minute, GETUTCDATE(),GETDATE()), GETutcDATE());
    Ajay Jain
    UK
Sign In or Register to comment.