On Tue, Jun 25, 2002 at 02:09:56PM -0400, Kipp, James wrote: > > > > Oracle stores the date as a number. This works out as the > > number of seconds > > from a significant date (in Oracle's mind). Therefore, you > > must send it as > > a date (or number). The to_char function returns the character > > representation of the number stored in the field. > > so then it does not matter how i format it before when i insert it? what i > mean if i insert a date that is formatted to "25-Jun-2002 13:44"(no seconds) > and this is entered into a date field in 2 seperate tables a second apart > (but still both display "25-Jun-2002 13:44" if queried) the 2 will still not > be equal?
You do not need to format the date at all when you insert it. If you store the date 25-Jun-2002 13:44 in two tables, the two *will* be equal. It doesn't matter what time it is in the real world when you insert the fixed date. Ronald
