Oracle Date Extraction and Date Filters

I was recently working on date manipulation in oracle DB.
I came across different scenarios and had to go back to basics.
Used the following links for a date refresher.

• Date Components Extraction
  
• Date Truncation
  
• Date Round
  
• Oracle Date Functions
  

Date Truncation

TRUNC(date_column, 'HH24')