Luch schreef:
> some of our customers need to operate in zulu time but must keep the
> box their Oracle DB is on in local time (such as Eastern).
>
> We wrote a stored proc to convert the sysdate from their local time
> into zulu. It works fine. But some programmers will still call SYSDate
> from their code, which is bad because then the "wrong" time is
> returned and they won't realize it when developing.
>
> my thinking is to override the sysdate function. Is this possible? I
> welcome any suggestions on how to deal with above issue.
>
timestamp with timezone, anyone?
Or are you still on a no-longer-supported-version?
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Feb 28 2007 - 12:49:27 CST
