/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

2 votes63 views1 answer
Sql group by different columns
SQL
1 vote112 views1 answer
Mysql last year
SQL
0 vote101 views1 answer
Check connections to database postgres
SQL
0 vote101 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote96 views1 answer
Mysql database is not starting in xampp
SQL
16 votes106 views6 answers
Install sqlite3 python
SQL
0 vote109 views1 answer
Mysql random number between 1 and 100
SQL
1 vote131 views1 answer
Drop colum oracle 18c
SQL
23 votes112 views3 answers
Sql where contains part of string
SQL
0 vote101 views1 answer
Mysql search multiple tables
SQL

Share