Posted by Joseph Melnick on 06/28/05 23:05

HawkEye Wrote:
"HawkEye" <sunbed@rocketmail.com> wrote in message
news:OLydnZ0oeeLAA1zfRVnyvw@pipex.net...
> Terry wrote:
>> Joseph Melnick wrote:
>>
>>> Terry wrote:
>>>
>>> "Terry" <tknospa@wejuggle2.com> wrote in message
>>> news:42c144fb$1_1@spool9-west.superfeed.net...
>>>
>>>> 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!

now() is in format: YYYY-MM-DD HH:MI:SS
curdate() YYYY-MM-DD

Joseph Melnick

[Back to original message]