Hi, i have TIMESTAMP column and i must convert his value in to date in mysql
Printable View
Hi, i have TIMESTAMP column and i must convert his value in to date in mysql
A timestamp column is already a date format. What exactly are you trying to do?
how i can extract the month and year
Since you haven't stated in what language you are attempting this, I will assume PHP.
PHP Code:$row = mysql_fetch_object($sql);
$monthyear = date('F Y', strtotime($row->timestamp))
thanks