/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

4 votes111 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote115 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
2 votes115 views2 answers
Oracle create table if not exists
SQL
11 votes118 views1 answer
Ddl materialized view
SQL
0 vote122 views1 answer
Suhaib
SQL
0 vote119 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote114 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote71 views1 answer
Ms sql print more than 1 variable
SQL
4 votes120 views1 answer
For loop postgresql
SQL
0 vote113 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL

Share