get month value from date stamp

[portman]

Hi,

 

I'm new to php,

 

I'm trying to get the month value from a date stamp (ie I have a variable with the following sort of value: 2014-08-20 07:32:20 )

 

how do I create a new variable with just the month values (ie 08) of the date stamp??

 

any help would be appreciated.

 

Thanks !

[PravinS]

Try this:

echo date("m",strtotime('2014-08-20 07:32:20'));

[CroNiX]

If 2014-08-20 07:32:20 is coming from a datetime/timestamp/date field in a query, you can also get the month from that using SQL and not use PHP.

SELECT MONTH(datetime_field) AS month

http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html