Filter on the date part of a SQL datetime field
Posted on 2006-04-11
I have a VB.NET application which works with a SQL database. In the SQL I have a table which contains 2 datetime values.
In VB I want my application to show all records with a datetime value in a certain filter. The probem is that the filter in VB is a date filter.
My question is how can I check on the date part of a datetime column in SQL. The time can be whatever it is, as long as the date is correct.
in Vb the filter is 01/01/01 00:00:00
In SQL the FromDateTimefield is 01/01/01 13:00:00 and the ToDateTimeField is 01/01/01 14:00:00
sqlCmd = New SqlCommand("SELECT * FROM Table WHERE @d BETWEEN FromDateTime AND ToDateTime", objSQLConn)
=> @d is not between the fromdatetime and the todatetime because of the 00:00:00 part.
Tnx for the help!