Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 77

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st November 2002, 16:23
spartacus's Avatar
spartacus spartacus is offline
Guru
 
Join Date: Dec 2001
Location: Germany
Posts: 773
spartacus is on a distinguished road
Baan: BaanERP 5.0c - DB: Oracle 8 - OS: SunOS 5.9
ERP <-> Oracle dates

We have a ERP 5.0c with an oracle database.

During check of a time value, we found the following values, for one table field, with differnent access methods:

(german date formats: DDMMYYYY)

27112002 00:00 Baan
26112002 23:00 Access via ODBC
26112002 Oracle via SQL


Does sombody know a reason for that?


Spartacus
Reply With Quote
  #2  
Old 21st November 2002, 16:50
lbencic's Avatar
lbencic lbencic is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
Are there any time zone issues? Maybe Baan is converting using UTC?
Reply With Quote
  #3  
Old 21st November 2002, 17:17
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Indeed Baan stores dates in UTC in Baan 5.0c
Reply With Quote
  #4  
Old 21st November 2002, 17:31
spartacus's Avatar
spartacus spartacus is offline
Guru
 
Join Date: Dec 2001
Location: Germany
Posts: 773
spartacus is on a distinguished road
Baan: BaanERP 5.0c - DB: Oracle 8 - OS: SunOS 5.9
Hi Ibenic,

as far as I know there is nothing about a time zone. If you are right there have to be a transormation, somewhere between Baan and Oracle?



Spartacus
Reply With Quote
  #5  
Old 21st November 2002, 17:34
lbencic's Avatar
lbencic lbencic is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
Yes, there is. In most ways that you view the data in Baan 5, it is run through the UTC format and you see a Date/Time relative to your time zone. In a direct view of the database, you would see the base time zone value.

How did you query the data in Baan? Viewed in a session? GTM? I think they all convert it for you. Try changing your time zone for your user and see if your view of the date/time changes in Baan.
Reply With Quote
  #6  
Old 22nd November 2002, 16:57
spartacus's Avatar
spartacus spartacus is offline
Guru
 
Join Date: Dec 2001
Location: Germany
Posts: 773
spartacus is on a distinguished road
Baan: BaanERP 5.0c - DB: Oracle 8 - OS: SunOS 5.9
Hi Ibencic,

I didn't do the queries by myself. I only know that the value in Baan is checked via ttaad4100, Access using some ODMC connection and in oracle the collegue used a SQL statement.

But I think your proposal is totaly right.

We have on Oracle GMT, and in Baan GMT + 1 h, what is right for Germany.


Thanks
Spartacus
Reply With Quote
Sponsored Links
  #7  
Old 17th October 2019, 09:38
Marius Titulesc Marius Titulesc is offline
Member
 
Join Date: Jun 2016
Posts: 41
Marius Titulesc is on a distinguished road
Baan: none - DB: Clearvision - OS: Windows 7
It works fine for me with Ibencic's proposal.
Thanks for sharing!
____________________________________________
Marius from ERP system
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
SSA ERP-NL / Baan V6 is it Vaporware ? tjbyfield General Discussion & Chat 18 1st October 2004 11:50
Oracle select for Baan NULL dates in where clause jroberts Operating Systems & Databases 6 18th June 2004 17:56
Docu: functions --> ERP DLL's spartacus Tools Development 3 19th November 2002 21:17
Error installing B4c4 with Oracle 8.1.7 on NT syllepage Tools Administration & Installation 2 22nd July 2002 14:52


All times are GMT +2. The time now is 14:05.


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