/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 vote353 views2 answers
On update cascade
SQL
57 votes562 views6 answers
Sql alter table
SQL
0 vote359 views1 answer
Opensuse stop MySQL
SQL
0 vote316 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote454 views1 answer
Trigger
SQL
0 vote348 views1 answer
What is logical database schema
SQL
5 votes368 views2 answers
Mysql create database charset utf8mb4
SQL
4 votes450 views4 answers
Remove duplicate old value in mysql
SQL
10 votes344 views4 answers
Primary key sql
SQL
0 vote357 views1 answer
Postgres enumerated type
SQL

Share