How to: |
Given a date or timestamp and a component, DTRUNC returns the first date within the period specified by that component.
DTRUNC(date_or_timestamp, date_period)
where:
Date or date-time
Is the date or timestamp of interest.
Is the period whose starting date you want to find. Can be one of the following:
DTRUNC returns the first date of the quarter given the date of birth:
DTRUNC(DATE_OF_BIRTH,QUARTER)
For 1993/03/27, the result is 1993/03/01.
iWay Software |