/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

2 votes308 views3 answers
3 days back in sql server
SQL
11 votes322 views1 answer
Oracle insert into where
SQL
0 vote319 views1 answer
On sql table data exists
SQL
0 vote312 views1 answer
Insert array into mysql column
SQL
11 votes337 views3 answers
Sql line numbers
SQL
0 vote339 views2 answers
How to count codition
SQL
1 vote331 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
1 vote346 views1 answer
Mysql take number in string
SQL
0 vote353 views1 answer
Sql sort ages
SQL
0 vote340 views1 answer
Oracle grant create job
SQL

Share