As a matter of fact I am refering to ORACLE and the TO_CHAR which I find quite usefull.
I have written a very poor and inflexable PHP function to do this outside the database. I have not played with doing my own functions in mySQL but your suggestion is well taken. I believe that I will attempt to create a function for mySQL that is more compatible and flexable. Good suggestion not sure why I didn't think of it :) Serge. > 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 --------------------------------------------------------------------- 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
