Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 1st September 2015, 04: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, 08:46
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,355
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, 14: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, 16:20
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,355
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, 09:24
günther günther is offline
Guru
 
Join Date: Jan 2002
Location: Ehingen, Germany
Posts: 574
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 11:47
Creating EDI 850(Out) for Warehouses in Different Time Zones wski64@yahoo.co Distribution, Transportation & Warehousing 1 4th May 2006 05:38
time zone cannot be used Predator Manufacturing & Supply Chain 0 20th May 2005 18:00
Time Conversion... suhas-mahajan Tools Development 6 8th October 2004 06:41


All times are GMT +2. The time now is 09:19.


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