search for: g1smd

Displaying 1 result from an estimated 1 matches for "g1smd".

2006 May 03
6
sql server, date and time
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