Re: Dumb Question of the day (maybe year)

Terry wrote: 
Joseph Melnick wrote:

Terry wrote:

"Terry" <tknospa@xxxxxxxxxxxxx> wrote in message news:42c144fb$1_1@xxxxxxxxxxxxxxxxxxxxxxxxxxxx

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

I have looked at the manual for MySQL and php, googled - this is so simple no one else has a problem, right?

TIA



Hello Terry,

Did you try to optionally quote the date field on import?

"2005-05-23";hello; 

I have now - same result.
"2001-21-06";hello; \r\n
"20002106";goodby; \r\n
Yields:
Date           comment
0000-00-00     hello
0000-00-00     goodby


Are you trying to use the current date (ie today) ? If so use curdate() or now(). One is for date and one datetime (I forget which)

HTH

--
Regards

Neil

Registered Linux User 324599
If vegetarians eat vegetables, beware of humanitarians!
.

Relevant Pages