/SQL/Oracle default date format

Oracle default date format

Oracle set date format

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';
SELECT sysdate FROM dual;

SELECT to_char(sysdate,'HH24:MI:SS') FROM dual;

4

Oracle default date format

SELECT
  TO_DATE( '24-JUL-21', 'DD-MON-RR' )
FROM
  dual;

0

Similar codes

0 vote202 views1 answer
To Create directory
SQL
0 vote204 views1 answer
Query to insert image
SQL
0 vote211 views1 answer
Openquery join two tables
SQL
0 vote176 views1 answer
Mysql count grouped rows
SQL
1 vote184 views2 answers
Oracle list service names
SQL
0 vote165 views5 answers
Sql table intermédiaire
SQL
1 vote133 views1 answer
Mssql string length
SQL
18 votes258 views3 answers
Get the list of all tables in sql server
SQL
0 vote173 views1 answer
Postgresql newline character
SQL
0 vote218 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL

Share