|
From: Rob M. <Rob...@co...> - 2006-02-18 14:54:33
|
Jack Eidsness wrote: > > I assume they are referring to one of the SQL standards out there, but > this normalization is apparently up to individual java developers (or > the jdbc driver developers?), and in the case of oracle jdbc, > undesirable. > > -Jack Eidsness Jack, According to SQL-92 the datetime types are: DATE - Year, Month and Day components TIME - Hour, Minute and Second components TIMESTAMP - Year, Month, Day, Hour, Minute, Second components. It seems correct then, that the hour, minute and second fields would be "0" when one uses an Oracle's Date datatype. I can recall switching to TIMESTAMPs in the past when I needed this granularity. Either that, or simply storing millis in a number field. Rob |
