I am currently comparing 2 tables to one another based on their respective date fields. One has the time listed as 00:00:00 and the other has an exact time. I need to set the one with the exact time to 00:00:00 so that the dates will match up properly. LIKE won't work in this instance because I am using the data in a Crystal Report and it doesn't like it. Thanks in advance for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SET TIME in DateTime
- Thread starter klmc
- Start date
nigelrivett
IS-IT--Management
where convert(varchar(8),dte,112) = convert(varchar(8),dte2,112)
where datediff(dd,dte1,dte2) = 0
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
where datediff(dd,dte1,dte2) = 0
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
- Status
Similar threads
- Locked
- Question
- Locked
- Question