/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

0 vote418 views1 answer
Add two days to current date in sql when creating tables
SQL
5 votes364 views3 answers
MySql get fields of table
SQL
0 vote369 views1 answer
Vbscript connect mssql
SQL
0 vote334 views1 answer
Mysql autoincrement valor inicial
SQL
13 votes353 views2 answers
Sqlite rename table
SQL
0 vote340 views1 answer
Insert thai language sql server
SQL
0 vote347 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote386 views1 answer
Reindex mssql table
SQL
1 vote331 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote355 views1 answer
Postgresql delete limit
SQL

Share