Re: [U2] Database time question

2013-01-24 Thread Hona, David
Potentially simple approach is to have separate server or virtual machine for 
your other UDT environment setup with the desired timezone. No code changes. On 
AIX, you can setup a WPAR for stuff like this pretty easily.

Or change you source code...

The best solution depends on if you control the source code for the application 
and how it currently extracts and utilises the time information. By 
implication, you will also need to separately maintain the date information as 
well in your application. Especially, if it cross the multiple timezones or the 
international dateline...

One approach is to ask the user to specify the timezone they wish or simply 
force it when they get into the respective account. 

Then you merely store a time offset (to your servers real time zone) in a 
separate field in addition to the time / date fields in your respective files 
(perhaps using a file based trigger if you don't want to change the code). Then 
just update date  time display routines (a good time to make sure you have a 
single routine) to check if there is an offset and apply prior to displaying.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey
Sent: Thursday, 24 January 2013 4:45 AM
To: U2 Users List
Subject: [U2] Database time question

Running unidata on hpux11.11i
I have two databases in unidata that I would like to operate at different time 
zones.
Lets say my Midvale database is set to mountain standard, USA which is also the 
base unix kernal time.
I have an account called Austrailia, I would like it to run on australian time.

Any ideas on making a unidata database independant of the unix kernal time.

Thank You

Robert Frailey
Manager Information Systems
Utah Medical Products Inc.
Femcare-Nikomed Ltd.
rfrai...@utahmed.com
801-569-4016


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Database time question

2013-01-23 Thread Robert Frailey

Running unidata on hpux11.11i
I have two databases in unidata that I would like to operate at different 
time zones.
Lets say my Midvale database is set to mountain standard, USA which is also 
the base unix kernal time.
I have an account called Austrailia, I would like it to run on australian 
time.


Any ideas on making a unidata database independant of the unix kernal time.

Thank You

Robert Frailey
Manager Information Systems
Utah Medical Products Inc.
Femcare-Nikomed Ltd.
rfrai...@utahmed.com
801-569-4016


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Database time question

2013-01-23 Thread Mark Eastwood
Only a guess - try setting the time zone using the unix command TZ





-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey
Sent: Wednesday, January 23, 2013 10:45 AM
To: U2 Users List
Subject: [U2] Database time question

Running unidata on hpux11.11i
I have two databases in unidata that I would like to operate at different time 
zones.
Lets say my Midvale database is set to mountain standard, USA which is also the 
base unix kernal time.
I have an account called Austrailia, I would like it to run on australian time.

Any ideas on making a unidata database independant of the unix kernal time.

Thank You

Robert Frailey
Manager Information Systems
Utah Medical Products Inc.
Femcare-Nikomed Ltd.
rfrai...@utahmed.com
801-569-4016


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users