Re: Date Woes - Serge Paquin - com.mysql.lists.mysql

9 messages in com.mysql.lists.mysqlRe: Date Woes

From	Sent On	Attachments
Serge Paquin	15 Oct 2002 09:10
gerald_clark	15 Oct 2002 09:53
walt	15 Oct 2002 10:16
Greg Knaddison	15 Oct 2002 10:20
Keith C. Ivey	15 Oct 2002 11:45
Serge Paquin	15 Oct 2002 15:18
Serge Paquin	15 Oct 2002 15:23
Iain Lang	17 Oct 2002 09:25
Brent Macnaughton	17 Oct 2002 12:37

Subject:	Re: Date Woes
From:	Serge Paquin (ser...@planetcharter.com)
Date:	10/15/2002 03:18:56 PM
List:	com.mysql.lists.mysql

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]

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-serge=skyc...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php