[Openroad-users] Timezone Question

[Pete Rabjohns]

How about using a batch job which accepts a parameter of timezone,
changes the II_TIMEZONE_NAME using ingsetenv and dumps the results of
SELECT DATE('now') into a file, which you can then read and parse in
4gl. 

 

I think you may be able to just change II_TiIMEZONE_NAME for the thread
you are calling by just setting the Windows Env Variable.

 

Sorry, not tested this to see if it works - I don't have the right
environment at the moment.

 

Pete

 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Darren
Harvey
Sent: 11 March 2008 21:34
To: 'International OpenROAD Users'
Subject: Re: [Openroad-users] Timezone Question

 

Hi Gareth

 

Unfortunately the need is a bit more complex than that.  We have
external clocking devices that are connected via TCP/IP and may exist in
any Timezone, and we need to be able to send the local time to these
devices. I will allocate a Timezone type variable to the definition of
the clocks. My theory is that we know that the TIMEZONE the clock
resides in is 'AUSTRALIA-SOUTH' or 'AUSTRALIA-WEST' or 'NZ', etc. And I
need to be able to send a string parameter to the clocks that contains
the correct local time.  I don't want to rely on just adding or
deducting a pre-specified number of minutes from the server based time,
as we need to take into account Daylight Savings changes.  So I would
like to have some method to get me the current time for a specified
Timezone.

 

Thanks

 

Darren

 

 

 

Regards

 

Darren Harvey

 

 

 

MyWorkplace Solutions Pty Limited

Level 5, 11 Queens Road

Melbourne Victoria 3004

 

Ph.       1300 733 731

Mob.     0400 398 188

Fax.      03 9710 1112

 

Making Service our Priority

 

www.MyWorkplace.com.au

 

If you receive this email by mistake, please notify us and do not make
any use of the email. We do not waive any privilege, confidentiality or
copyright associated with it.

 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
gareth.2.edwards at bt.com
Sent: Tuesday, 11 March 2008 10:46 PM
To: openroad-users at peerlessit.com
Subject: Re: [Openroad-users] Timezone Question

 

Just take half an hour off?

 

ACDT = date('now') - '30 mins';

Cheers, 
Gareth Edwards 

BT Global Services 
tel: +44 (0)131 345 3629 
email: gareth.2.edwards at bt.com <mailto:gareth.2.edwards at bt.com>  

 

	 

	
________________________________


	From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Darren
Harvey
	Sent: Friday, March 07, 2008 6:25 AM
	To: 'OpenRoad Users'
	Subject: [Openroad-users] Timezone Question

	Hi All

	 

	I need to be able to determine the current time in a different
Timezone.  For example:  If my Ingres Timezone parameter is set to
'AUSTRALIA-VICTORIA', how can I determine the current time in
'AUSTRALIA-SOUTH'?

	 

	(Using OR2006 with Ingres2006)

	 

	 

	Thanks

	 

	Darren

	 

	Regards

	 

	Darren Harvey

	 

	

	 

	MyWorkplace Solutions Pty Limited

	Level 5, 11 Queens Road

	Melbourne Victoria 3004

	 

	Ph.       1300 733 731

	Mob.     0400 398 188

	Fax.      03 9710 1112

	 

	Making Service our Priority

	 

	www.MyWorkplace.com.au

	 

	If you receive this email by mistake, please notify us and do
not make any use of the email. We do not waive any privilege,
confidentiality or copyright associated with it.

	 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080311/cc09b4fb/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1436 bytes
Desc: image001.jpg
Url : http://www.peerlessit.com/pipermail/openroad-users/attachments/20080311/cc09b4fb/attachment-0001.jpe