An Entrepreneur, Coach, IT Consultant, Strategic Adviser, and a Traveler craving to explore and contribute to forming a better society.

Thursday, June 18, 2009

Date Difference in Oracle Database

No comments :
Date Difference in Oracle Database

How to find date difference in Oracle Database?

The answer is simple: 

SQL> SELECT TO_DATE(SYSDATE)-TO_DATE(DATECOLUMN) FROM TBL_NAME

SQL> SELECT SYSDATE-DATECOLUMN FROM TBL_NAME

Featured Blog Topics:


No comments :