TRUNC function to use on numeric DATE

As I told in my previous posts you can apply better way Date functions to work with dates. This special post I am explaining to apply on numeric date.


The TRUNC function truncates date to year. That means it gets date to yyyy- 01-01 from the input PERIODIC_DATE.


  • This function most frequently being used in data warehousing projects.
  • This is one of the best way to work with Date related functions.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.