Hi, I have a date in a string like so "May 02, 2001 09:15:57" and this date is not a standard MySQL date and so it wont insert correctly. My question is this, is there a function to convert the date to something that MySQL can understand or do I have to convert it manualy? Thanks in advance. Andy Woolley. --------------------------------------------------------------------- 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