|
|
Posted by the good guy on 07/01/05 15:28
There is a better way to resolve this.
Instead of using a "human" readable date like 2001-21-06 (which is 21st Jun
2001), you should use Unix Timestamp instead. Conversion can be done via
http://www.php.net/manual/en/function.mktime.php
And whenever you need to display the actual human date, just use date()
function. date() is able to control the format of the date.
If you going to set the field of your table to date, you will have to comply
with the MySQL format for date. If you use the Unix Timestamp, you can avoid
using the date field format and use plain old varchar.
"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!
Navigation:
[Reply to this message]
|