Replace just the time value for some not all records in in date time field
Hello- I need a way to replace time on records that are not 12:00. Some of the records load with 12:00 AM as the time and some do not. For the ones that are not 12:00 AM, I want to replace the time on there with 12:00 AM. I don't want to split up the date and time into seperate columns.