Hello Andrew/Arun

Thanks guys.. I found the solution in both your posts... i.e. Andrew's 1st Post and Arun's

So!! My query looks like this....

SELECT CAST(DATEADD(day, DATEDIFF(day, TB_BOOKING_ITEMS.PICKUP_TIME, 0), PICKUP_TIME) AS SMALLDATETIME) FROM...

Hello Andrew,

Thanks for your reply.

Your solution does extract the correct time with the date set to zero, however the result that I get still has the Micro seconds. It looks...