date from timestamp

How to Extract Date from Timestamp

The best idea to get DATE and TIME from Timestamp. This is one of the better way to use DATE function in SQL query. It is also a best DATE example.