Thursday, September 13, 2012

Default Display Format for Date Field in Oracle SQL Developer

i was running very simple query as given below

Date was displayed in DD-MON-YY format. For a given date, second column i.e. invoice_amount was not displaying in right order. It made me think for a while and then i realized that creation date has time component too and that is why invoice amount is not in desired order. Truncating invoice date solved the problem.

This link explains how to change default display format of date column in SQL Developer.

No comments:

Post a Comment