Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 22nd January 2009, 16:18
kmarella kmarella is offline
Member
 
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

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

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
Reply With Quote
Reply


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 wski64@yahoo.co 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 14:24.


©2001-2018 - Baanboard.com - Baanforums.com