Hi Andrew,
DATE_FORMAT is the function you're looking for.
Check the documentation on it, chapter 6.3.4 "Date and Time Functions".
DATE_FORMAT works like the following:
SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
BTW, SQL Server offers the CONVERT function for this purpose. No need to use some VB
script in order to convert strings into dates.
Best regards,
Wolf
Hi - I am relatively new to MySQL, previous experience is mainly Visual
FoxPro and MS SQL2000.
I have a client who supplies data in text files. In numerous of these
files and subsequent tables there are date fields.
In the UK we use the date format of dd/mm/yyyy. I understand that MySQL
only accepts data in yyyy-mm-dd, and as far as keeping the data in MySQL
I don't have a problem with that, but somehow I have to get the data
into MySQL tables from the text files.
In SQL Server, I can do this using some VB script in a DTS... is there
anything similar, or, does anyone have any other ideas?
Many thanks
Andrew
____________________________
JM Data Services
8 Stanton Road
Wimbledon
LONDON
SW20 8RL
t: 020-8286 8545
f: 020-8944 8621
m: 07801-866043
e: [EMAIL PROTECTED]
---------------------------------------------------------------------
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
