Re: Dumb Question of the day (maybe year)

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

.

Relevant Pages