date.sql

SELECT name FROM enrolled WHERE enroll_date = TO_DATE('10/10/96','DD/MM/YY');

To get the minutes and seconds from a date use the TO_CHAR formatting function:

	SELECT TO_CHAR(sysdate,'dd-mon-yy hh:mi:ss am') Todays_date FROM dual;

	TODAYS_DATE
	12-nov-96 20:54 pm

To ignore the minutes and seconds use the TRUNC function on both sides of the specification:

	SELECT po_num FROM purchase_orders WHERE TRUNC(po_date)>TRUNC(sysdate);
	
	
SELECT (UPDATE_DT-CREATE_DT)*86400 FROM CREDIT_REPORT_REQUEST
WHERE TRUNC(CREATE_DT)>TRUNC(SYSDATE-1);