/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 vote189 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote179 views1 answer
Count the table indatabase
SQL
0 vote184 views1 answer
Increment id in mysql
SQL
2 votes250 views3 answers
Mysql kill
SQL
0 vote228 views1 answer
Calculer pourcentage mysql
SQL
0 vote233 views1 answer
Mysql command line top 10
SQL
1 vote211 views2 answers
Procedure syntax
SQL
12 votes243 views6 answers
How to install sqlite3 in python
SQL
3 votes193 views3 answers
Remove all spaces from string sql
SQL
0 vote201 views2 answers
Close external port 3306 with iptables
SQL

Share