TIMESAMP into mysql

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