To change the format that a date is displayed in Oracle use the set NLS_DATE_FORMAT command. For example, if you wanted to show hours minutes and seconds with a date time stamp you could use: -
alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY HH:MI'
before executing your query.
Showing posts with label Alter Session. Show all posts
Showing posts with label Alter Session. Show all posts
Monday, 19 July 2010
Subscribe to:
Posts (Atom)
