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.
-----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. ___________________________________________________________________________ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
