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)

No comments: