Horje
oracle default date format Code Example
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;
oracle default date format 
SELECT
  TO_DATE( '24-JUL-21', 'DD-MON-RR' )
FROM
  dual;



Sql

Related
SQL add a totals of differemt rows of the same id Code Example SQL add a totals of differemt rows of the same id Code Example
select lowest values sql Code Example select lowest values sql Code Example
complete date is 1 year or not sql server Code Example complete date is 1 year or not sql server Code Example
MySQL FIND_IN_SET() Code Example MySQL FIND_IN_SET() Code Example
oracle merge insert if not exists Code Example oracle merge insert if not exists Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje