I took over a project and I have a need for hour interval data, but the application was coded to store it in 'h' (standard 12h time with no AM or PM delegation). I have an idea of how to adjust the rows but I'm not sure how to structure the update query. This is what I have to work with:
Unique ascending ID
12h Time
mm/dd/yyyy date
I was thinking I could run a query that looks for values less than 12:00 in the time column and then add 12:00 to it if that Unique ID is > the biggest ID for an existing item with 12:00 - 12:59 for that specific day. Is this feasible and if so does anyone have any ideas on how to structure the update query?
