/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

2 votes278 views1 answer
Sql view column data type
SQL
12 votes363 views6 answers
How to install sqlite3 in python
SQL
0 vote390 views1 answer
Sql query for login with email or username
SQL
0 vote344 views1 answer
Column ' ' in field list is ambiguous
SQL
10 votes353 views2 answers
SQL rounding numbers
SQL
0 vote314 views1 answer
Backup a table in sql
SQL
0 vote363 views1 answer
Pl/pgsql declare variable
SQL
34 votes398 views6 answers
Alter table add foreign key mysql
SQL
0 vote367 views1 answer
FIND most frequent word in sql server
SQL
0 vote371 views1 answer
Create user faunadb
SQL

Share