Return date as year

I wrote this little search query:

 User.where("strftime('%Y', birthday) = ?", 1994)

But somehow i get no search resuts although i now that i have several users with their birthday in 1994. In the Users Table birthday is defined as date

Now i have two ideas how i could solve my problem:

1.I could check what the result of "strftime('%Y', birthday) is for a specific user or the whole user collection. But i dont know the expression! Maybe you know the expression?

2.You know what i did wrong and you have an answer?

Thanks!

Answers


In Rails you can write the query like:

User.where("birthday BETWEEN '?-01-01' AND '?-12-31'",1994,1994)

See this post for why this kind of format is good performance-wise when compared to something that uses "YEAR": SQL query where() date's year is $year.


Need Your Help

Can you use multiple VaryByCustom parameters when caching a user control?

asp.net caching

I've been trying this a couple of different ways, but it's not working for some reason. Is it even possible?

Backbone: Adding a model to Collection and render a View

javascript backbone.js backbone-views backbone-routing

I'm building a simple Backbone app where I mainly have a view with a list of books (book name + cover image) and another view where I want to add new books to the list.