Re: Dumb Question of the day (maybe year)

On 28 Jun 2005 14:50:45 -0700, "NC" <nc@xxxxxxxxx> 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
Well, I dunno - I mean, has anybody *tried* 21 months in the year? Is it
significant that it's precisely half the Answer to Life, the Universe and
Everything.
Maybe the OP has stumbled across something.
.

Relevant Pages