, January 11, 2007 12:49 AM
Subject: how to take advantage of STR_TO_DATE
Hello the list
I have a bunch of data that I load in the base through
the load data infile procedure.
These data contain date with the following date format :
%d/%m/%Y [ that is day/month/year_4digit ]
I could rewrite
On 1/11/07, Gilles MISSONNIER [EMAIL PROTECTED] wrote:
hello,
I rewrite my question in a simpler (?) way :
How could I load in the database, data from a text file containaing date
in a NOT MySQL standard date format [precisely char(10)], so that I get
the date into a MySQL standard date format
[EMAIL PROTECTED] (Gilles MISSONNIER) wrote in
news:[EMAIL PROTECTED]:
I rewrite my question in a simpler (?) way :
How could I load in the database, data from a text file containaing
date in a NOT MySQL standard date format [precisely char(10)], so that
I get the date into a MySQL standard
In the last episode (Jan 11), Jake Peavy said:
On 1/11/07, Gilles MISSONNIER [EMAIL PROTECTED] wrote:
How could I load in the database, data from a text file containaing
date in a NOT MySQL standard date format [precisely char(10)], so
that I get the date into a MySQL standard date format in a
On 1/11/07, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Jan 11), Jake Peavy said:
On 1/11/07, Gilles MISSONNIER [EMAIL PROTECTED] wrote:
How could I load in the database, data from a text file containaing
date in a NOT MySQL standard date format [precisely char(10)], so
that I
Hello the list
I have a bunch of data that I load in the base through
the load data infile procedure.
These data contain date with the following date format :
%d/%m/%Y [ that is day/month/year_4digit ]
I could rewrite the date with a script (perl, shell,)
to convert day/month/year_4digit into
Team
- Original Message -
From: Gilles MISSONNIER [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, January 11, 2007 12:49 AM
Subject: how to take advantage of STR_TO_DATE
Hello the list
I have a bunch of data that I load in the base through
the load data infile procedure