Ok, maybe I should use Timestamp ?? Thank you very much!!
DNewfield wrote: > > Tuncay A. wrote: >> I use Oracle and field data type is: Date > > Then that field will only store date information. If you want it to > store higher resolution, look into other types > http://www.devx.com/dbzone/Article/30501 > > One gotcha I remember figuring out a few years back regarding oracle > date types: They're multi-valued. I.E.: it stores more resolution that > it shows. The place this bites you is if you want to do something like: > > select count(id), birthday from people group by birthday order by > count(id) desc; > > to find out how many people share birthdays, it won't work. Someone > born at noon on 1/1/2000 and someone born at 2pm on 1/1/2000 won't group > together in oracle, because their values actually differ. > > -Dale > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Sample-data.xml-need-to-insert-timestamp---tf3966071s2369.html#a11261212 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
