Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
30%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
10%
1500 - 2000 GB
13%
> 2000 GB
20%
Total votes: 30

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 1st September 2015, 05:24
ken bohnenkamp ken bohnenkamp is offline
Senior Member
 
Join Date: Jul 2002
Posts: 100
ken bohnenkamp is on a distinguished road
Baan: B40C C4 - DB: Informix - OS: Unix
Time Zone Conversion
Baan: Baan IVc4
C/S: None/Unknown

I would like to convert a time in an eastern time zone to a time in a central time zone and then show it in a report. Does someone know an easy way to do this and what the syntax would look like ? I have looked at UTC functions but they are not real intuitive on what the syntax would look like. Does anyone have some code examples of how you can convert times in different time zones ?
Reply With Quote
  #2  
Old 1st September 2015, 09:46
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,356
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

Use get.time.zone() and set.time.zone() functions.

e.g.

Code:
domain tcdate dt 
string tz(50)

dt = utc.num()
get.time.zone(tz)    |# This will store your current time zone into tz
set.time.zone("America/Chicago") |# Set the required time zone


This will change the value of dt variable according to the required timezone at runtime.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 1st September 2015, 15:23
ken bohnenkamp ken bohnenkamp is offline
Senior Member
 
Join Date: Jul 2002
Posts: 100
ken bohnenkamp is on a distinguished road
Baan: B40C C4 - DB: Informix - OS: Unix
Time Zone Functions

Whenever I use the functions, I get the errors
unresolved reference to functions get.time.zone and set.time.zone
Reply With Quote
  #4  
Old 1st September 2015, 17:20
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,356
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

In that case, you might need to do it manually by adding/subtracting hours/mins from the current time in your current time zone.

Else, you can wait for a Baan 4 person to provide a working solution for this.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
  #5  
Old 3rd September 2015, 10:24
günther günther is offline
Guru
 
Join Date: Jan 2002
Location: Ehingen, Germany
Posts: 578
günther is on a distinguished road
Baan: IVc4 - DB: Informix - OS: HP-UX
Hi Ken.

Since you are on Unix, you could set TZ and parse the output of date, e.g.

$ TZ=MEZ-1MESZ date
Thu Sep 3 09:19:04 MESZ 2015
=> If TZ is "MEZ-1MESZ", then it's now 09:19:12.

$ TZ=MEZ date
Thu Sep 3 07:19:12 MEZ 2015
=> If TZ is "MEZ", then it's now 07:19:12.

Regards
Günther
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
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
Time Conversion... suhas-mahajan Tools Development 6 8th October 2004 07:41


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


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