/SQL/Oracle set date format

Oracle set 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

19 votes310 views6 answers
Laravel sql query
SQL
2 votes312 views2 answers
Exec procedure pl sql
SQL
2 votes358 views2 answers
Sqlalchemy return id after insert
SQL
1 vote352 views1 answer
Sql how to replace full stop
SQL
0 vote325 views1 answer
SQL loop with cursor
SQL
0 vote397 views1 answer
Intellij mysql set timezone
SQL
16 votes346 views6 answers
Python sqlite
SQL
4 votes342 views4 answers
What is primary key
SQL
0 vote326 views1 answer
Nosql vs sql
SQL
11 votes363 views1 answer
Oracle export view ddl
SQL

Share