How to extract Date from Timestamp

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

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.