I have been dowloading alot of queries using Oracle servers and displaying the results and the only good way to show dates is using YYYY-MM-DD in character format - this way, when I index it, it always works and looks good. Sometimes I have YYYY-MM for monthly sumaries as well so it is obvious what is going on to users in either case. This also avoids Y2K problems with sorting nicely...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only