/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 vote310 views1 answer
Show per page table in xampp
SQL
0 vote315 views1 answer
C# mysql update statement set value to null
SQL
5 votes319 views1 answer
Oracle sysdate - 1 month
SQL
0 vote315 views1 answer
Mysql date format unix timestamp
SQL
-1 vote324 views1 answer
Sql show custom constraints
SQL
0 vote292 views1 answer
Phpmyadmin mysql conflict
SQL
1 vote287 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote314 views1 answer
Mysqldump ignore table
SQL
2 votes292 views1 answer
Oracle sql query to make column data uppercase
SQL
15 votes303 views4 answers
Pl sql
SQL

Share