Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 22nd January 2009, 16:18
kmarella kmarella is offline
Join Date: Aug 2007
Posts: 53
kmarella is on a distinguished road
Baan: ERP LN - DB: Oracle - OS: Windows 2003
Time zone

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

K Marella
Reply With Quote
Old 31st January 2009, 01:57
Cesar Lopez Cesar Lopez is offline
Join Date: Jul 2006
Posts: 31
Cesar Lopez is on a distinguished road
Baan: ERP Baan V - DB: Oracle 9i - OS: HP-UX 11i

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.

Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Zone Designator / Diff between TimeZones iamdnb Tools Development 3 10th October 2012 12:47
Fatal Error for Time Zone raj_mirani Tools Development 2 10th September 2007 21:39
Creating EDI 850(Out) for Warehouses in Different Time Zones Distribution, Transportation & Warehousing 1 4th May 2006 06:38
time zone cannot be used Predator Manufacturing & Supply Chain 0 20th May 2005 19:00
UTC Format **SAT** Tools Development 10 24th September 2002 20:22

All times are GMT +2. The time now is 01:29.

©2001-2018 - -