/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

0 vote357 views1 answer
Connect laravel to mysql on mac
SQL
0 vote371 views1 answer
Prodection ready postgres database step by step
SQL
1 vote361 views1 answer
Oracle previous year
SQL
0 vote343 views1 answer
Show size of all tables postgres
SQL
21 votes362 views1 answer
SQL cheat sheet pdf
SQL
4 votes330 views1 answer
Mysql ip address
SQL
10 votes394 views2 answers
Doublon sql
SQL
0 vote305 views1 answer
How to get last client id sql
SQL
0 vote400 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
11 votes370 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL

Share