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

0 vote251 views1 answer
Como hacer un select entre fechas mysql
SQL
5 votes257 views1 answer
Oracle nls instance
SQL
0 vote252 views1 answer
Find invalid datetime field
SQL
1 vote262 views1 answer
Sql upsert
SQL
19 votes216 views1 answer
Sqrt(-1)
SQL
4 votes254 views1 answer
Add constraint fk
SQL
5 votes309 views1 answer
Oracle ora-00054 find
SQL
92 votes439 views6 answers
Substring
SQL
18 votes255 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote238 views1 answer
How to fetch highest score in minimum time using mysql
SQL