> > 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? > > -----Original Message----- > From: Kipp, James [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 25, 2002 11:20 AM > To: DBI-Users > Subject: RE: Inserting formatted Date > > > > > > What is the data type for the field into which you are > > inserting the date? > > If it's a DATE field, you do the formatting when you retrieve > > the value, > > not when you set it. If it's not a DATE field, it should be. > > the data type is 'date'. I wanted to format it as i insert > because the field > is a key on 2 tables i will be querying on (so the date/time > should be =)? i > guess the question would then be "how does oracle store the > date" ? meaning > if it is formatted then stored, does oracle still store it > like "6/25/2002 > 1:18:14 PM" anyway. >
