Timestamp from DB

[Miko]

Hi,

 

I have in my DB a column with a timestamp as definition.

Now I would like to have only the month and year of that column for further use in a form.

 

How can I achieve that?

 

Thanks!

[MMDE]

$yearandmonth=substr($timestamp,0,7);
$year=substr($timestamp,0,4);
$month=substr($timestamp,5,2);

[Pikachu2000]

Or you can simply format it in the query string, instead of using some convoluted php code to format it. Assuming you're using MySQL:

SELECT DATE_FORMAT(`timestamp_field`, '%M, %Y) AS stamp FROM `table` . . .  etc.