I have a stored procedure in which I pull two values from a table. These are both datetime fields one being the date and the other being the time. In my stored procedure I would like to compare the result of concatenating these two fields with todays date. My problem is that each time I concatenate the date and time it deletes two days from the result e.g.
I am looking for 07/05/2005 12:00:00
but it returns
It makes no sense. Please help!! Thanks,