i would always insert milliseconds in an int field.
saves you a lot of irritation ;)
tibi
Tuncay A. wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
