/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 vote295 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote288 views1 answer
Mysql select smaller of two values
SQL
2 votes304 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
1 vote301 views1 answer
Mysql return if it contains
SQL
3 votes289 views2 answers
Sql get month name
SQL
11 votes296 views1 answer
Oracle insert into where
SQL
0 vote276 views1 answer
IS THEre any difference between using default and := in plsql
SQL
11 votes276 views2 answers
MySQL DISTINCT
SQL
2 votes291 views2 answers
How to check data type in sql server
SQL
0 vote279 views1 answer
Import sql dump into postgresql database
SQL

Share