Serge Paquin wrote: > Hello All, > > I'm just plugging away at a converion project where we are migrating to >mySQL. I am getting increasingly down on the poor support for importing dates into >mySQL. In the near future could we expect a function that is basicaly the opposite >to date_format where the first param is a date and the second param is the format of >that string. The function would return a mySQL compatible date sutable to be used in >an INSERT or UPDATE statement. > > Thanks, > Serge. > > --------------------------------------------------------------------- > 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
We had the same issues your having converting from oracle to mysql so we wrote 2 functions (perl) to convert the dates. One for just the date and the other for DateTime. One other hint, if you insert ' ' into a date field, when you retreive the value, it will be 0000-00-00. The same thing happens with numeric fields. walt --------------------------------------------------------------------- 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
