date without time
This is a discussion on date without time within the MySQL forums, part of the Database Server Software category; --> whenever i output my sql tables to html, the date column has the date followed by 00:00:00.00, does anyone ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:35 AM
| |||
| |||
 Re: date without time 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 http://dev.mysql.com/doc/refman/5.0/...functions.html Regards, Bill K.      |
|
02-28-2008, 08:36 AM
| |||
| |||
| Re: date without time 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 http://dev.mysql.com/doc/refman/5.0/...functions.html > > 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'.... |
|
02-28-2008, 08:36 AM
| ||||
| ||||
| Re: date without time 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. |
Linear Mode
