Posted by Terry on 06/29/05 01:38

NC wrote:

> Terry wrote:
>
>>I am using phpMyAdmin to access MySQL for inputting data - built one
>>table - no problems. I am uploading text files using ; as a delimiter.
>> Second table includes a date (configured as date not datetime). I have
>>tried:
>>2001-21-06;hello; \r\n
>>20002106;goodby; \r\n
>>'2001-21-06';hello; \r\n
>>'20002106';goodby; \r\n
>>
>>All I get is:
>>Date comment
>>0000-00-00 hello
>
>
> MySQL requires dates being imported to be in YYYY-MM-DD format; so to
> MySQL, "2001-21-06" appears to be an invalid date, since there are only
>
> 12 months in a year, not 21, as you propose...
>
> Cheers,
> NC
>
<blush>Thanks, I was just getting ready to post that</blush> - in the
text file no quotes (single or double nor the dashes) are needed.

Thanks to all!

--
TK
http://www.wejuggle2.com/
Still Having a Ball







..

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[Back to original message]