Our programming crew does not give us (Web Services) access to Oracle. We of course don't care kuz' mySQL suits us fine. But now we have run into a pickle. They are handing us text cdf files for import. One of the fields they are giving us is in the following condition:
02-SEP-02 We need to do a conversion of that to a `real' datetime format. I know of a function in php that will convert that but I need this in SQL only. Any ideas? Rob. --------------------------------------------------------------------- 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