SQL: How to Drill Down Timestamp with DATE_TRUNC Function

Here’s an example to extract year from timestamp using DATE_TRUNC function.

DATE_TRUCN Function

DATE_TRUNC ( PERIODIC_DATE, YEAR)

The TRUNC function truncates DATE to year. The input DATE is YYYY-MM-DD. After TRUNC function, it changes to YEAR. That means to YYYY-01-01.

Uses of DATE_TRUNC Function

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

References

• More examples of DATE_TRUNC

Related Posts