/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

8 votes174 views1 answer
Oracle search code in packages
SQL
13 votes176 views1 answer
Sql join 3 tables on id
SQL
0 vote171 views1 answer
Oracle current session details
SQL
9 votes185 views5 answers
Sql delete duplicate rows but keep one
SQL
1 vote165 views1 answer
Search for tables with name postgresql
SQL
25 votes212 views4 answers
Import mysql dump command line
SQL
20 votes169 views5 answers
Reset auto increment mysql
SQL
0 vote153 views4 answers
Sql limit 1 offset 1
SQL
0 vote174 views1 answer
Linked server delete openquery
SQL
0 vote180 views1 answer
Mariadb maximum left join
SQL

Share