When we boot our AIX system, it shows the current date and time as GMT (UTC?) and our time zone is EST, therefore when I do a "date" at the Unix prompt, I get:
Thu Oct 28 16:25:44 EST 2004 And when I do a "DATE" at our UniData prompt, I get: Thu Oct 28 16:26:00 EST 2004 These are giving me the correct time and date. When I do "echo $TZ" at a Unix prompt, I get: EST5EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00 Therefore, our time zone is correct as far as Unix and UniData goes. However, when I run the command: LIST WORK.ORDER DT TM SAMPLE 10 through a UniObjects program (see below), It gives me the "raw" date and time - with no time zone offset applied. So my question is, where does UniObjects get the time zone when a dictionary containing @TIME, TIME(), @DATE or DATE() is run? btw, I don't see anything in my .profile that has anything to do with time zone. Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -----Original Message----- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 2:35 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] UniObjects and Time zones You haven't got something in your account login that is setting timezone stuff perhaps? Uniobjects bypasses the login. Also are you running the uo session under the same user as the telnet session that is giving you the correct date? Might be set in profile. ________________________________ From: [EMAIL PROTECTED] on behalf of Burwell, Edward Sent: Thu 28/10/2004 15:08 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] UniObjects and Time zones Yes, I am on Unix (AIX) and it would seem to be a time zone issue. Any dictionary containing @DATE, DATE(), @TIME or TIME(), that is "run" by UniObjects is giving me GMT. How can I "tell" UniObjects to apply our time zone? Thanks Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -----Original Message----- From: Mark Eastwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 11:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Assuming you're on Unix - there is an environmental setting "tz" for timezone. Try man on tz or timezone. -----Original Message----- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 10:06 AM To: [EMAIL PROTECTED] Subject: Spam:RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Regardless, the @DATE and @TIME are different by about 5 hours. Is there a setting in UniObjects that determines or sets the time zone that I'm in? -----Original Message----- From: Bob Witney [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 6:52 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? Yes @TIME on Universe is the proces start time as an intiger (regardless of what the book says) and TIME() is the actual time with decimals i.e 42716 42716.8421 42716 42717.8422 42716 42718.8424 Bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: 27 October 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? @DATE and @TIME are not necessarily the current date and time, they are the date and time the current command/program started. I've seen this as differences in a program between @TIME and TIME(), which always returns the current time. I'm away from my server at the moment and can't verify this, but I suspect that @TIME might be the time that your UniObjects session began. Brian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 27 October 2004 01:49 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] Where does UniObject get @DATE and @TIME from? Hello all, I have a file with 2 dictionaries. One called DT and the other TM: DT 001 V 002 @DATE I also tried DATE() and got the same thing 003 004 005 5R 006 S TM 001 V 002 @TIME I also tried TIME() and got the same thing 003 004 005 6R 006 S When I run a simple UniQuery statement, I get exactly what you'd expect LIST WORK.ORDER DT TM SAMPLE 5 WORK ORDER. DT... TM.... 584367 13449 74797 593333 13449 74797 628402 13449 74797 663471 13449 74797 698540 13449 74797 5 records listed HOWEVER... When I run this through UniOjects, I get: LIST WORK.ORDER DT TM SAMPLE 5 01:48:20 Oct 27 2004 1 WORK ORDER. DT... TM.... 584367 13450 6500 593333 13450 6500 628402 13450 6500 663471 13450 6500 698540 13450 6500 5 records listed I am running UniData 5.2 on AIX 4.3.2. It's around 20:48 on 10/26/2004 as I write this. The time and date is right on our Unix box and it's correct on my XP PC. My control panel, regional and date and time setting are correct also. I am on the East Coast of the US. (and it seems to be off by 5 hours, hmmmmmmmmmmm) Where does UniObjects get the @DATE and @TIME variables? Thanks. Ed Burwell ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ______________________________________________________________________ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. ______________________________________________________________________ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ______________________________________________________________________ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. ______________________________________________________________________ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ______________________________________________________________________ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. ______________________________________________________________________ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
