Dear Xperts,

We are facing a issue with Timezone. When the time zone was set to GMT or GTM+2.00 , the record was mismacthing between General Table Maintenance (GTM) and database level. Could some one tell us what could be the cause for this.

System: Windows 2003server
Database: Ms-SQL 2005.
ERP : Baan5.2b

Regards
K Marella

The date/time showed in any session and report pass thru a function which converts the data from UTC and taking in count the timezone from your user template, but at the very end the date/time is saved in the database with UTC, in order to show in any timezone depending of the user template of the user, and supporting many timezones at the same time.

But this is a nightmare for some stuffs like reporting, i work in a bug corporation, and what we do, is put the server(unix) in UTC, and then all the user templates with a timezone located in UTC, in this way the function is not going to add or substract any from the original hour, and the date/time showed is the same than the saved in the database.

in b5c and Lnfp3 the timezone africa/casablanca works great for this purpose.


Regards