I have columns with the following date format:

06/01/2007


I want to convert this to 06/01/2007 00:00:00 AM/PM so it can be used in a calculation.

how do i do this