Serge, What are you used to in the database that you are migrating from?
My guess on what would be nice is something like the ORACLE to_date and to_char functions, which work in query strings and load data statements: http://www.llcsystems.com/FAQ/oracle_SQL/oracle_SQL_11.htm Though if someone wants a function to do something, can't you just write your own and then publish it for all to enjoy(hint hint Serge)? Perhaps if it's good enough it would be added to the MySQL set of core functions to everyone's benefit? http://www.mysql.com/doc/en/Adding_UDF.html Greg -----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED]] Perl has functions to do this. If you are writing an import, use language native functions. For a "load data in file", just how would you expect this to work? 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
