Displaying 1 result from an estimated 1 matches for "birthday_pages".
2006 Feb 20
1
extract month from date column
Hi,
I have this rails query:
@birthdays = Birthday.find :all,
:conditions => ["user_id = ? and
birthdate = ''2006-02-01'', @user_id],
:limit => @birthday_pages.items_per_page,
:offset => @birthday_pages.current.offset
You can ignore the user_id, limit and offset part. Birthdate is date
type. That query lists the row which birthdate is 2006-02-01. How do I
extract month from birthdate column; something like this:
.... bi...