Calculate DAYS, HOURS, MINUTES, SECONDS, MILLISECONDS

EXAMPLE - 1
Calculate The Difference In DAYS, HOURS, MINUTES, SECONDS & MILLISECONDS But The Datatype Used By The Columns Are In VARCHAR2

If your columns datatypes are not in DATE datatype so you have to conver it into DATE datatype before performing any operation. Here we  have to put TO_DATE date function with your column name i.e. TO_DATE(COLUMN_NAME,'MM/DD/YYYY HH:MI:SS'), This function will convert your column's data into date format after that you can perform your operations to calculate the Days, Hours, Minutes, Seconds & Milliseconds

PROCEDURE

EXAMPLE -2
Calculate The Difference In DAYS, HOURS, MINUTES, SECONDS & MILLISECONDS Of TIMESTAMP datatypes

NOTE: IF YOU HAVE DOUBTS, KINDLY CONTACT ME VIA THIS BLOG

SUM OF TWO COLUMNS (COLUMN1+COLUMN2) & SUM(COLUMN NAME) FUNCTION OPERATION WITH NULL VALUES, WHAT WOULD BE IT'S OUTPUT?

> SELECT COL1, COL2, COL3, COL4, COL1+COL2, COL2+COL3, COL3+COL4, COL1+COL4 FROM TEMP_TABLE
> SELECT SUM(COL1), SUM(COL2), SUM(COL3), SUM(COL4) FROM TEMP_TABLE



CREATE TABLE TEMP_TABLE 
(
  COL1 VARCHAR2(10), 
  COL2 VARCHAR2(10), 
  COL3 VARCHAR2(10), 
  COL4 VARCHAR2(10)
);

INSERT INTO TEMP_TABLE VALUES ('10','20','30','40');
INSERT INTO TEMP_TABLE VALUES ('10','','30','40');
INSERT INTO TEMP_TABLE VALUES ('10','','','40');
INSERT INTO TEMP_TABLE VALUES ('','','','');










SUM OF COLUMNS: SUM WITH NULL ALWAYS RETURN A NULL VALUE
SELECT COL1, COL2, COL3, COL4, COL1+COL2, COL2+COL3, COL3+COL4, COL1+COL4 FROM TEMP_TABLE 










SUM FUNCTION WITH INDIVIDUAL COLUMN NAME: WILL RETURN THE SUM OF THE COLUMN EITHER THE COLUMN CONTAINS NULL
SELECT SUM(COL1), SUM(COL2), SUM(COL3), SUM(COL4) FROM TEMP_TABLE










NOTE: IF YOU HAVE DOUBTS, KINDLY CONTACT ME VIA THIS BLOG