How to get month from month/date/year?

I have saved values in a table of type date named so_mpt_date.

Example of dates stored in database are:
a) 1/3/2002 --means January 3, 2002
b) 10/24/1999 -- October 24, 1999

How do I get the month values only in its number form--
Specifically 1 (from a)or 10(from b) from the given example..

Thanks in advance...

ereg('(.)/(.)/(.*)',$string,$stripped);
$month=$stripped[1];

$string is the date string (1/3/2002) and $month is the month number.

Good Luck!

You can try this query :

Select DATE_FORMAT(Your_DateField, '%m') My_Month From your_Table Where ...

The field My_Month will be the result you are waiting for !

good luck.