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
15%
200 - 500 GB
30%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
11%
1500 - 2000 GB
15%
> 2000 GB
22%
Total votes: 27

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 20th July 2008, 12:11
iamdnb's Avatar
iamdnb iamdnb is offline
Member
 
Join Date: Jan 2003
Location: Delhi, India
Posts: 58
iamdnb is on a distinguished road
Baan: BaaN IV - DB: SQL Server - OS: Windows NT
Time Zone Designator / Diff between TimeZones
Baan: iBaanERP 5.0c
C/S: None/Unknown

Hi,

I am working on a project with a requirement to convert the date as per ISO-8601 format for which I have to find the TZD (Time Zone Designator) i.e. the difference between the user's time zone and GMT.

I could not find any ready function to find the same. I will appreciate if someone could suggest some function in Baan which could be used to calculate the TZD.

Davendra
Reply With Quote
Sponsored Links
  #2  
Old 21st July 2008, 00:23
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,070
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
I found the functions in the LN Tools versions, I am not sure if its available in Baan-5 series, you have to check with the Baan Support.
Quote:
iso.to.utc()
Syntax:
function long iso.to.utc (const string iso.string)

Description
This converts a string, representing a time in ISO-8601 format into a utc.

Arguments
const string iso.string

Return values
>0 The UTC long format value.
<0 Error.

Context
This function can be used in all script types.

utc.to.iso()
Syntax:
function string utc.to.iso (string utc, long format)

Description

This converts a utc into a string representation of the utc in ISO8601 format.

Arguments
string utc
long format Can be one of the following constants:

UTC_ISO_DIFF with time-zone "yyyy-mm-ddThh:mm:ss + hh:mm" or

"yyyy-mm-ddThh:mm:ss - hh:mm"
UTC_ISO_Z as GMT "yyyy-mm-ddThh:mm:ssZ"
UTC_ISO_LOCAL with as local date/time "yyyy-mm-ddThh:mm:ss

Return values
The string representation of the UTC in ISO-8601 format.

Context
This function can be used in all script types.
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #3  
Old 23rd July 2008, 18:50
iamdnb's Avatar
iamdnb iamdnb is offline
Member
 
Join Date: Jan 2003
Location: Delhi, India
Posts: 58
iamdnb is on a distinguished road
Baan: BaaN IV - DB: SQL Server - OS: Windows NT
Solution - UTC to ISO & vice-versa

Thanks NPRao (Guru).

Unfortunately, the functions mentioned by you are not available in BaaN V. Anyways, I had to write my own functions to achieve the results. I am attaching the source for both functions iso.to.utc() and utc.to.iso() for everybody's reference.

Thanks for the support.

Regards
Davendra
Attached Files
File Type: txt iso.to.utc.txt (415 Bytes, 85 views)
File Type: txt utc.to.iso.txt (1.4 KB, 61 views)
Reply With Quote
  #4  
Old 10th October 2012, 12:47
baanhp's Avatar
baanhp baanhp is offline
Member
 
Join Date: Dec 2009
Posts: 69
baanhp is on a distinguished road
Baan: Ln - DB: sql2000 - OS: windows server 2003
Dear Sir,

The same requirement is in BAAN iv,unfortunately your code is not working in BAAN iv,because the standard function get.time.zone() function and date.to.date() functions are not working in BAAN IV .

Kindly guide me some alternative way to code in BAAN IV



Thanks for your valuable help in advance .



Regards
Haraprasad
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
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
UT-Datum Kai's Forum Users Deutsches Forum 1 29th May 2000 01:00


All times are GMT +2. The time now is 06:39.


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