/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 votes198 views1 answer
Drop table if exists in postgres
SQL
0 vote209 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote223 views1 answer
Can't connect to postgresql mac os
SQL
5 votes222 views3 answers
Db begintransaction laravel
SQL
0 vote223 views1 answer
Python connect microsoft sql server
SQL
0 vote230 views1 answer
Postgres row expiration
SQL
9 votes194 views2 answers
Cmd to rename a collumn name in sql
SQL
-1 vote203 views2 answers
How to display top 50 rows?
SQL
0 vote234 views1 answer
Add mysql database to power bi web
SQL
0 vote227 views1 answer
Copy Table from SQL to CSV
SQL

Share