Hey there all,
Is there some way to tell rails or sql server to ignore the time in a
datetime field when doing a comparison?
For example, if I do something like
select * from users where registration_date = ?, @date
where @date might equal some user input like ‘03/14/2006’
The result is nothing returned, because in my tables the datetime
field looks like this:
3/14/2006 4:04:00 PM
I would like to tell rails or sql server to ignore the time, so that
these rows will be returned as well. Anyone with any ideas? I’m sure
this is something trivial and I’m just not seeing it.