[Openroad-users] Timezone Question

[Paul White]

Hi Darren,

You could set the II_TIMEZONE environment variable before activating
OpenROAD
Different timezones can be run simultaneously in this way.

run_sa.bat
set II_TIMEZONE=AUSTRALIA-SOUTH
w4glrun ....

run_nt.bat
set II_TIMEZONE=AUSTRALIA-NORTH
w4glrun....


I think the interpretation of timezones is part of ingres net.
Eg In two command windows run this:

set II_TIMEZONE=AUSTRALIA-SOUTH
sql mydb 
select date ('now')  \g

set II_TIMEZONE=AUSTRALIA-NORTH
sql mydb 
select date ('now')  \g


Paul



  -----Original Message-----
  From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com]On Behalf Of Darren Harvey
  Sent: Friday, 7 March 2008 4:25 PM
  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/5c85e883/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3055 bytes
Desc: not available
Url : http://www.peerlessit.com/pipermail/openroad-users/attachments/20080311/5c85e883/attachment.bin