Hello all, When I run the following query:
I get this: Looking at the cashout_stopdate column, you will see that there are actual hrs, minutes, and seconds. I need to know if I can convert these to 00:00:00.000, or remove them somehow to where I only have 2012-02-27 date? I have to get rid of the hh:mm:ss in order for the sums to total correctly. any help would be appreciated.
(comments are locked)
|
what version of SQL Server are you working with?
@Fatherjack
I am using SQL Server 2008 R2.
in that case use
@FatherJack
I tried this and it works. Thank you so much!!!!!