/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

3 votes195 views2 answers
Sql asc
SQL
5 votes208 views1 answer
Oracle get foreign keys on table
SQL
0 vote316 views1 answer
How to get table current identity value in sql server
SQL
1 vote150 views1 answer
Python escape string for sql
SQL
0 vote239 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote212 views1 answer
Drop view in mysql
SQL
0 vote844 views2 answers
Remove mysql workbench ubuntu
SQL
7 votes197 views4 answers
What is my mysql version
SQL
1 vote208 views1 answer
Full sql mode
SQL
3 votes206 views2 answers
Sql get month name
SQL

Share