How to get DATE Only From DATETIME Column

Here is an SQL query to get only Date from the Datetime column. This is tested in Oracle. Also, added SQL query to get both Date and Time.