/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

4 votes134 views3 answers
How to describe a table in sqlite3
SQL
0 vote128 views1 answer
Sql contains numeric characters
SQL
0 vote149 views1 answer
Postgresql import a database of gzip
SQL
5 votes126 views1 answer
Alter table add comment oracle
SQL
14 votes138 views2 answers
Oracle limit rows
SQL
0 vote132 views1 answer
Data structures in sql
SQL
8 votes148 views1 answer
Show mysql user table
SQL
15 votes161 views4 answers
Sql update from select
SQL
0 vote180 views2 answers
SQL BULK INSERT
SQL
1 vote127 views1 answer
Sql myisam vs innodb
SQL

Share