February 26th, 2004, 07:41 PM
I have a form that users fill out online and then submit to my oracle database. One of the fields is the date when the form is submitted. I have it declared as a "date" data type, is that what I should be using or should I just use char? I am having a problem inserting the date because it says that it is in the wrong format. Suggestions?
February 27th, 2004, 12:04 AM
Originally Posted by jp1234
you need to convert date field what you are retrieving from
before inserting into db.
February 27th, 2004, 08:40 AM
I was using to_date to convert it, but not to that format, I thought the default was YYYY-MM-DD?