Time conversion

I have a question about automatic daylight savings time conversion in ORACLE. In applications that we build, we'd like to allow the user to enter, view, and query time as wall clock time but have ORACLE store it as standard time in the database. That is, ORACLE would take responsibility for translating between Daylight Savings Time and Standard Time (if the need arises).

I am familiar with the time conversion service provided by ORACLE which allows one to convert time from one zone to another. However, this means that the program must still decide whether the time zone is standard or dst and then call this service. Also, in this case the application has to take responsibility for converting the entered time into standard time before storing it in the database. Similar complications arise when time is to be viewed or used in a query.

If anyone is aware of a less tedious approach to solving the daylight savings time problem, I'd like to hear about it.

Thanks very much.

Aru
na_at_abb-sc.com

ABB Systems Control
Santa Clara, CA. 95051 Received on Wed Aug 23 1995 - 00:00:00 CEST