Monday 28 October 2013

how to split month , year , day from date in php

date('m',strtotime('22-5-2013'))

if u have date data-type then it also possible on this way ..............

date('m',strtotime($arr[1]))

in which $arr[1] is date like 22-10-2013 store in database using date data-type

2nd way ,,,,

SELECT * FROM sochvote WHERE facid=$faculty_name and YEAR( STR_TO_DATE( voteDate,  '%d/%m/%Y' ) ) =$year_name ")