Extracting the date and time independently from a timestamp is also very easy:

Use Date and Time Functions in SQL Query to Extract Date and Time from Timestamp

DATE (current timestamp)
TIME (current timestamp)

Related Posts