TRUNC function to use on numeric DATE

The best example for TRUNC function that truncates to nearest date format in SQL