Displaying 1 result from an estimated 1 matches for "end_of_the_month".
2006 Feb 20
1
extract month from date column
...h birthdate is 2006-02-01. How do I
extract month from birthdate column; something like this:
.... birthdate.month = 2 .....
I want to query all the rows which in February or another month.
I have though the solution; something like this:
.... birthdate >= start_of_the_month and birthdate <= end_of_the_month
.... ( we find start and end of the month from ruby )
but maybe rails has simpler way....
Thank you.