Time Diffrence in SQL and Navision

minty_friend
minty_friend Member Posts: 38
edited 2013-09-04 in NAV/Navision Classic Client
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

  • geronimo
    geronimo 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
  • kine
    kine 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.
  • ajayjain
    ajayjain 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

Categories