/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

1 vote118 views1 answer
Oracle first row
SQL
38 votes195 views6 answers
Ubuntu install mysql client
SQL
0 vote115 views1 answer
Sql missing values
SQL
4 votes257 views2 answers
Sql display today's date
SQL
2 votes143 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
1 vote124 views1 answer
How to select random rows from a table
SQL
3 votes110 views1 answer
Oracle list user grants
SQL
7 votes137 views4 answers
Mysql delete older duplicates
SQL
6 votes135 views2 answers
What is non relational database
SQL
0 vote142 views1 answer
What is server_default = func.now() in sqlalchemy
SQL

Share