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?
Casting usually works fairly well for true Datetime columns.
Cast("Datetime Column" as Date)
In Redshift there is a function called TRUNC that strips the timestamp:
Thank you! This was exactly what I needed.
Using the TRUNC function has been the best solution in my experince for this.