Page 1 of 1
Display date format
Posted: Sun Feb 25, 2007 10:10 pm
by S_henry
Hi guys..
If i just display data from table, it will be displayed as '2007-02-25 00:00:00'. How can i display that data by the format of '25.02.2007'?
Thanks..
Re: Display date format
Posted: Sun Feb 25, 2007 10:50 pm
by volka
Hi. Please be more specific.
S_henry wrote:If i just display data from table
A html table? Database table? Dinner table?
Posted: Mon Feb 26, 2007 12:22 am
by S_henry
Sorry..i mean if i just extract the data from mysql database, that data will be displayed as '2007-02-25 00:00:00' in html. In mysql table, the field type is 'datetime'. So how can i display that data by the format of '25.02.2007' in html?
Posted: Mon Feb 26, 2007 12:25 am
by volka
You might be interested in DATE_FORMAT(date,format) at
http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html
Posted: Mon Feb 26, 2007 2:28 am
by S_henry
OK. Solved already. Thank you.
