Hi,
I am a new user to MySql, and have recently installed version 3.23.25-beta.
I have a date string of the type 'DD-MON-YY' (for Oracle Users) (Eg.
20-DEC-01')
If I try to insert this into a date field in the table, either as it is, or
via the DATE_FORMAT function, it inserts a NULL
Even when I try to "Select DATE_FORMAT('20-DEC-01', '%d-%m-%Y')" it returns
a Null.
If I convert this as 20-12-01, it returns a 01-12-2020.
Please let me know how to interpret such date strings for inserting into the
database, as also whether there is an equivalent of TO_DATE() from Oracle in
MySql.
-Vaishali--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
