/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 vote194 views1 answer
Find largest table in mysql database
SQL
0 vote214 views1 answer
Case when with count and combining similar values in sql
SQL
25 votes195 views6 answers
Modify column name in mysql
SQL
8 votes207 views1 answer
How to check mysql version in xampp
SQL
13 votes207 views2 answers
Oracle inner join
SQL
0 vote153 views1 answer
Get last run query sql server
SQL
8 votes301 views2 answers
Select current_timestamp - interval '3 days';
SQL
1 vote218 views1 answer
Postgresql round double precision
SQL
0 vote207 views1 answer
Add sqlcmd to path linux
SQL
0 vote208 views1 answer
Postgresql check total storage
SQL

Share