/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

1 vote198 views1 answer
Oracle see column type
SQL
0 vote151 views1 answer
Search In the Data using ObjectName
SQL
0 vote150 views1 answer
Set open file limit mac catalina mysql
SQL
20 votes130 views5 answers
Sql show tables
SQL
3 votes134 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
3 votes156 views3 answers
1396(hy00) mysql error
SQL
19 votes137 views6 answers
Laravel sql query
SQL
0 vote136 views1 answer
Mysql 1 hour ago
SQL
0 vote134 views1 answer
Difference between min and max date sql
SQL
28 votes101 views6 answers
Distinct sql
SQL

Share