Nancy,
I would keep the time stored as-is. I
can't stress enough that you don't want to store it based on local time.
Just tweak it on output. That solves your interstate trucker issues. 12:01
PM to 4:01 PM is four hours 100% of the time if you store based in a
single time zone.
There are a lot of ways to
tweak on output. The easiest is to set up shell accounts (or real
accounts, depending on how you slice your data) and put a one line call in
all your software something like this, wherever you have
OCONV(VALUE,'D2/') code:
NOW =
DATE()
CALL TIME.CONV(NOW, 'D2/')
PRINT NOW
SUBROUTINE
TIME.CONV(VALUE,MODE)
* <comments>
.
.
.
IF
ACCT = 'MT' THEN
<adjust output for Mountain
Time>
END ELSE
<show time as is>
END
VALUE = OCONV(VALUE,MODE)
RETURN
--
Charles Barouch
[EMAIL PROTECTED] - Consulting
[EMAIL PROTECTED] - ETL/Migration/Integration
(718) 762-3884x1
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
