sweeb Posted September 15, 2011 Share Posted September 15, 2011 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? Link to comment https://forums.phpfreaks.com/topic/247215-jury-rigged-military-time/ Share on other sites More sharing options...
Pikachu2000 Posted September 15, 2011 Share Posted September 15, 2011 Not enough information. Are there only 2 records for any given date? How can you be sure the second entry is indeed PM? Link to comment https://forums.phpfreaks.com/topic/247215-jury-rigged-military-time/#findComment-1269720 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.