How do I format a date field in Oracle?
How do I format a date field in Oracle? Set the date format. SQL> ALTER SESSION SET NLS_DATE_FORMAT=’DD-MON-YYYY HH24:MI:SS’; Create a table table_dt with columns c_id and c_dt . The c_id column is of NUMBER datatype and helps to identify the method by which the data is entered. What is current date format in Oracle? […]