/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

12 votes292 views6 answers
Between in sql
SQL
0 vote282 views1 answer
Equi joins in oracle
SQL
1 vote284 views1 answer
Mysql show long running queries
SQL
0 vote316 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
16 votes318 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote303 views1 answer
Sqlserver create table from select
SQL
0 vote317 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote291 views1 answer
Drop df constraint sql server
SQL
11 votes288 views3 answers
Sqlite3 create table from another table
SQL
0 vote356 views1 answer
Compress sql file database ubuntu
SQL

Share