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? Quote Link to comment 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.