Couple questions about retrieving/displaying dates and times from a DB. The DB is for a college, they have classes that occur once (possibly twice) a week at the same time each day. The time may span AM-PM. My question is how should I store the day and time info so that a) I can sort by day (Mon, Tue, Wed, etc.) and how can I store the time in one field so it's possible to tell if it's am/pm? I'd much rather use 24hr time, but it's a US school running on 12hr time so it doesn't make much sense to convert back and forth. Further, I'm considering using an array to store the retrieved rows such that they're referenced record(j,i). In doing this though, I can't be sure which field I'm working with so it's hard to know how to filter/prepare records before display. So how do I handle filtering sorting?