[eluser]dbashyal[/eluser]
i have a date in the format of YYYY-MM-DD in the table and i want to select all rows that belongs to month = 01, is there any easy method to do this.
i have made a separate field for month and pulling data checking the month field, as the project was due soon.
But, I am wondering if i can do above query without creating separate field month coz sometime i may have to query for year or even day and then i have to store date in separate fields day, month and year.