/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 vote237 views1 answer
Call procedure in wordpress
SQL
0 vote250 views1 answer
Sql decimal to 2 places
SQL
0 vote222 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
5 votes221 views2 answers
Oracle show procedures
SQL
8 votes224 views1 answer
Oracle add month
SQL
0 vote246 views1 answer
How to combine first and last nae into one columb sql
SQL
1 vote274 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote234 views1 answer
Show per page table in xampp
SQL
0 vote227 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote242 views1 answer
Get relation data in mysql using query to excel
SQL

Share