Well, found the problem with my strange output. Turns out the first query selects all records. The first group of records displayed were entered into my table in 24-hour format. When looking at the records displayed in the second query, the records truly appear in 12-hour format with the AM and PM listed.
However, is there still a way to convert the data displayed in my second query to a 24-hour format while leaving the actual records themselves in 12-hour format? Thanks!