/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

0 vote153 views1 answer
T sql dynamic top n query
SQL
4 votes145 views1 answer
W3schools create table
SQL
0 vote129 views1 answer
Sql database connectivity
SQL
0 vote151 views1 answer
Sql server isnull function nor working count
SQL
1 vote125 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote133 views2 answers
Start mysql server using docker
SQL
0 vote128 views1 answer
Mysql select statement after index
SQL
0 vote139 views2 answers
Sql update top 100
SQL
0 vote142 views1 answer
Oracle synonym procedure dblink
SQL
0 vote150 views1 answer
Oracle list user locked
SQL

Share