Re: Dumb Question of the day (maybe year)

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 =----
.

Relevant Pages

  • Re: Dumb Question of the day (maybe year)
    ... Joseph Melnick wrote: ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ...
    (alt.php)
  • Re: Dumb Question of the day (maybe year)
    ... Terry wrote: ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ...
    (alt.php)
  • Re: Dumb Question of the day (maybe year)
    ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ... If vegetarians eat vegetables, beware of humanitarians! ...
    (alt.php)
  • Excel Date Time to Unix Time
    ... I am uploading this feild into mysql I need the datetime to be converted to ...
    (microsoft.public.excel)
  • Excel Date Time to Unix Time
    ... I am uploading this feild into mysql I need the datetime to be converted to ...
    (microsoft.public.excel.programming)