VB.Net - Query to compare Datetime in SQL Server
Posted on 2013-12-27
Good Day Experts!
I struggle much with comparing dates from my SQL Server db.
I have 2 tables with date fields. One is smalldatetime/4 with no time 2013-12-17 00:00:00. The other is datetime/8 with time 2013-12-17 07:19:04.300.
Field 1 does not get populated with the time. So, when I compare the 2 fields if the dates are the same I need Field 2 to be greater since it has a time on it.
Can I do that? Do you have any resource sites that can help me achieve this?