/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

4 votes216 views2 answers
Mysql delete user if exists
SQL
0 vote221 views1 answer
Update having mysql
SQL
1 vote193 views1 answer
Oracle current sequence value
SQL
0 vote207 views1 answer
Select last 2 characters sql
SQL
1 vote195 views2 answers
How to check username in mysql command line
SQL
1 vote202 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote190 views1 answer
Hibernate with springboot mysql
SQL
0 vote211 views1 answer
How to set sql_mode for a query in CI model
SQL
2 votes219 views1 answer
Q operator in oracle
SQL
5 votes202 views1 answer
Postgresql functions
SQL

Share