/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

1 vote120 views3 answers
Mysql parse int
SQL
0 vote122 views1 answer
Create mysql pool connection python flask
SQL
0 vote129 views1 answer
Codigo crear tablas sql server
SQL
1 vote137 views1 answer
Oracle extract minute from date
SQL
0 vote118 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
4 votes112 views1 answer
Sql any
SQL
0 vote124 views1 answer
Get statis values sql
SQL
1 vote122 views2 answers
Procedure syntax
SQL
-3 votes107 views1 answer
Remove spaces sql 2008
SQL
0 vote136 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL

Share