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.