date without time

[Kun]

whenever i output my sql tables to html, the date column has the date
followed by 00:00:00.00, does anyone know how to remove that?

[Bill Karwin]

Kun wrote:

> whenever i output my sql tables to html, the date column has the date
> followed by 00:00:00.00, does anyone know how to remove that?

Would the DATE_FORMAT() function help?

See [url]http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html[/url]

Regards,
Bill K.

[Kun]

Bill Karwin wrote:

> Kun wrote:

>> whenever i output my sql tables to html, the date column has the date
>> followed by 00:00:00.00, does anyone know how to remove that?

>
> Would the DATE_FORMAT() function help?
>
> See [url]http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html[/url]
>
> Regards,
> Bill K.

but why isn't the 'date' column operating as it is suppose to? it seems
like it is turning itself into 'datetime' when it is suppose to be
'date'....

[Bill Karwin]

Kun wrote:

> but why isn't the 'date' column operating as it is suppose to? it seems
> like it is turning itself into 'datetime' when it is suppose to be
> 'date'....

What are you using to produce the HTML output? MySQL doesn't do this by
itself, so you must be using some tool or something. Perhaps it is
doing the conversion of DATE to DATETIME inappropriately?

Regards,
Bill K.