The data type for the date column is DATE. I can't show you the order the rows are returned because I'm at a different computer right now.
I do believe however, the rows returned were in the same order as stored in the database. Is 'date' a valid column name? I really don't have any ideas what's wrong here. Thanks for the help.