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;

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

Similar codes

1 vote280 views1 answer
Too many connections mysql
SQL
0 vote262 views1 answer
Find most frequent value in SQL column
SQL
1 vote246 views2 answers
Mysql SELECT
SQL
0 vote285 views1 answer
How to create a table based on another table in mysql
SQL
1 vote289 views1 answer
Mysql print variable
SQL
7 votes278 views2 answers
What is sql clause
SQL
2 votes288 views1 answer
Ifnull postgres
SQL
13 votes265 views2 answers
Sql join
SQL
0 vote258 views2 answers
What is 1=2 in sql
SQL
0 vote276 views1 answer
Mysql workbench view
SQL