need help with TRUNC(date)
Can anyone please tell me what does this statement do in a query. Please focus on the date function. What does the TRUNC function do in the result.
SELECT DISTINCT BUS_UNIT, HOSP_DEPT_CODE, CLINIC_CODE, MD_CODE, TRUNC(APNTMNT_DATE) APNMTDATE
FROM A_APNTMNTS_MASTER
WHERE BUS_UNIT = :GLOBAL.M_BU_BUS_UNIT
AND TRUNC(APNTMNT_DATE) BETWEEN :A_APNTMNTS_MASTER_DATE.APNTMNT_DATE1
AND :A_APNTMNTS_MASTER_DATE.APNTMNT_DATE7;