/SQL/Oracle default date format

Oracle default 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 vote200 views1 answer
Test connection to sql server
SQL
1 vote202 views3 answers
Reset sql primary key
SQL
0 vote197 views1 answer
How to install mysql without admin rights
SQL
0 vote217 views1 answer
How to define a non primary composite key in sql
SQL
19 votes201 views6 answers
Sql drop table if exists
SQL
48 votes298 views3 answers
Psql create database
SQL
8 votes190 views2 answers
Mysql query dates between two dates
SQL
0 vote206 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote214 views1 answer
How to inner join 4 tables in sql
SQL
0 vote195 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL

Share