/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 vote287 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote275 views1 answer
Mariadb set vertical output format
SQL
8 votes277 views1 answer
Oracle search text in all packages
SQL
1 vote244 views1 answer
Add current timestamp in mysql
SQL
1 vote257 views1 answer
Oracle select first result
SQL
0 vote265 views1 answer
Postgresql linux password
SQL
0 vote260 views1 answer
Sql alter column name sql server
SQL
14 votes248 views1 answer
Excel is not a database
SQL
5 votes263 views1 answer
How to get all dates in a month in oracle
SQL
0 vote267 views1 answer
Create function in microsoft sql server
SQL

Share