Showing posts with label Date Time Format Settings. Show all posts
Showing posts with label Date Time Format Settings. Show all posts

Monday, November 26, 2012

Oracle SQL Developer Data Time Display Format




Oracle SQL Developer Date/Time Display Format Settings


Many Oracle SQL Developer users would have faced problem in displaying the date column value with time stamp. 

To display time stamp also along with Date, 

  • Need to navigate to Tools > Preference > Database > NLS section.
  • Update Date format to mm/dd/yyyy hh:mi:ss (We can specify whichever format we need)