/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 vote114 views1 answer
Count char in java
SQL
0 vote176 views2 answers
Sql if empty then
SQL
-1 vote150 views1 answer
How to open blade file from blade in laravel
SQL
10 votes239 views2 answers
Doublon sql
SQL
0 vote210 views2 answers
Search stored procedures by name
SQL
3 votes158 views2 answers
Sql random integer
SQL
1 vote147 views1 answer
Sql myisam vs innodb
SQL
0 vote177 views1 answer
Postgresql conectar
SQL
1 vote155 views1 answer
Oracle check table space
SQL
1 vote143 views1 answer
How to between in sql
SQL

Share