Re: JDBC to Dates/Times in Oracle

> I wrote:
> > This is rather what I was afraid of. I was sort of hoping that the SQL
> > standard would allow me sufficient database-independance to cope with
> > simple things like dates and times without writing code specific to each
> > different dbms.

Brian Dick wrote:
>
> Dates and times are not "simple things". If you consider different
> calendars, timezones, regionalization, and user preferences, dates and times
> are quite complex. Also, datetime has an infinite domain in both duration
> and precision. That's always a tough problem for a finite computer to
> handle.
> >

Yes, fair enough, they aren't entirely "simple" as such, that was a poor choice of words. However, in the context of an SQL standard that's been around for a number of years, is it too much to ask that major dbms vendors comply with it? Or have the date and time standards been changed in a later version of the standard? (I've only looked at SQL-92.)

-- 
Neil Campbell