/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

1 vote350 views1 answer
What is int in mysql
SQL
3 votes329 views1 answer
Mysql load sql from file
SQL
0 vote314 views1 answer
Postgresql import data from csv
SQL
2 votes332 views2 answers
Mysql show table column comments sql
SQL
-1 vote355 views1 answer
Default username and password for oracle 11g
SQL
7 votes329 views1 answer
Minecraft forge server host
SQL
0 vote352 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote349 views1 answer
Copy data from cell to cell mysql
SQL
0 vote334 views2 answers
Sql max count
SQL
8 votes332 views1 answer
Oracle all_source package body
SQL

Share