Redshift Date & Time to Date Syntax

Hi, 

 

I have a column in my redshift table that is stored as date and time ie 

6/3/2016 9:23:42 PM 

When creating the database, I would like to store only the date. What is the syntax for doing this? 

Best Answer

Answers