You cannot always control the data you are getting from external sources. Not everyone uses the ISO standard (Including the default from Oracle and MS SQL Server). We get data from outside sources and it would be much eaiser to deal with if mysql had such a function.
I'm not sure if I am blaming mySQL with the problem. It's a feature that both Oracle and MS SQL have the ability to do but mySQL cannot. It's a feature deficency that makes life harder to deal with Dates and mySQL if you don't want to use ISO. Serge. > On 15 Oct 2002, at 12:10, Serge Paquin wrote: > >> 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. > > Why are you blaming MySQL for that problem? You could just as well > say it was poor support for exporting dates in whatever you're using > to create the files you're importing. In fact, it seems to me that > not being able to create dates in the ISO standard format is a worse > problem than not being able to parse dates in a nonstandard format. > > [Filter fodder: SQL] > > -- > Keith C. Ivey <[EMAIL PROTECTED]> > Tobacco Documents Online > http://tobaccodocuments.org > > --------------------------------------------------------------------- > 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
