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