Only if the date being converted is a standard length, i.e. not 2/4/99
All dates would have to be DD/MM/YYYY or MM/DD/YYYY, eg. 02/04/1999
If so then yes it can be done in MySQL else u wouldn't know your /'s from
your dates
John (*\*)
-----Original Message-----
From: Bernhard Doebler [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2001 13:35
To: [EMAIL PROTECTED]
Subject: Re: LOAD DATA INFILE
Hi,
it seems to me I have to do something like this. It originally was my goal
to only use SQL but this does not seem to be possible. Or do you think it's
possible to reformat the string using left(), mid() and right() functions in
MySQL and put it in a date-field?
Best regards and thanks so far
Bernhard Doebler
----- Original Message -----
From: "John (*\*)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Bernhard Doebler" <[EMAIL PROTECTED]>
Sent: Thursday, July 05, 2001 2:13 PM
Subject: RE: LOAD DATA INFILE
> This is what i wrote to convert dates in PHP before putting them into db:
>
---------------------------------------------------------------------
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
