> > 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.