Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

need help with TRUNC(date)

ateeqrahmanMay 5 2010 — edited May 5 2010
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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2010
Added on May 5 2010
4 comments
3,554 views