#converting dates

Excel VBA, Working with Dates, Comparing, Adding, Subtracting ...

If you're working with dates in your excel sheets then you have to understand the date object. You can compare dates to see which one is more recent, you can add and subtract a certain amount of days month, years to a specific date. You can get the current date ....

You can quickly and simply 'explode' the timestamp right in your SQL by using the following:

SELECT *, MONTH(`timestamp`) as `Month`, YEAR(`timestamp`) as `Year` FROM `news` order by timestamp desc

From that you have now made (temporarily) two new fields: Month and Year. 

You can call them in your while loop (or which ever you like) as you normally would any other field in the array:

$row['Year'];