TIMESAMP into mysql

[ledaker]

Hi, i have TIMESTAMP column and i must convert his value in to date in mysql

[PeejAvery]

A timestamp column is already a date format. What exactly are you trying to do?

[ledaker]

how i can extract the month and year

[PeejAvery]

Since you haven't stated in what language you are attempting this, I will assume PHP.

$row = mysql_fetch_object($sql);
$monthyear = date('F Y', strtotime($row->timestamp))

[ledaker]

thanks