oracle trunc 1

oracle trunc

SELECT TRUNC( SYSDATE, 'Q' ) result
FROM  dual;
Code language: SQL (Structured Query Language) (sql)

Here is what the above code is Doing:
1. The TRUNC function is used to truncate a date to a specific unit of measure.
2. The SYSDATE function is used to return the current date and time.
3. The ‘Q’ parameter is used to truncate the date to the first day of the current quarter.

Similar Posts