I have DB with some field such as “orderno”, “orderqty” & “deliverydate”.
My deliverydate store in mysql table as yyyy-mm-dd, now i want to catch only month from the deliverydate, like if its 2011-04-23 then it will count as April month & for 2011-05-30 will show May & so on.
Is it possible to do it in php?
I want to do it to find out the total order quantity for each month. Need your kind help.