Getting month from mysql

[tito]

I have date time in database as linux timestamp

1195826703

Is it possible to do a SELECT STATEMENT to get data for month only. e.g. January, February...?

[NogDog]

SELECT MONTH(FROM_UNIXTIME(`timestamp_column`)) AS `month` . . .

[tito]

Thanks. I did

SELECT * FROM_UNIXTIME(column,'%Y-%M') as month