When I run the following query:
sum(cashouttot_systemtotal) as systemtotal,
SUM(actualtotal) AS actualtotal,
WHERE cashouttot_systemtotal <> 0.00
and cast(cashout_stopdate as date) = '02/27/2012'
GROUP by cashoutid, cashoutidbystore,
netdiffrence, PaymentName, cashout_stopdate
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.
May 17, 2012 at 01:58 PM