Redshift Date & Time to Date Syntax

user00341

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? 

PodiumMason

Casting usually works fairly well for true Datetime columns. 

 

http://docs.aws.amazon.com/redshift/latest/dg/r_CAST_function.html

 

Example: 

 

Cast("Datetime Column" as Date)

AS

In Redshift there is a function called TRUNC that strips the timestamp:

 

http://docs.aws.amazon.com/redshift/latest/dg/r_TRUNC_date.html

PodiumMason

Casting usually works fairly well for true Datetime columns. 

 

http://docs.aws.amazon.com/redshift/latest/dg/r_CAST_function.html

 

Example: 

 

Cast("Datetime Column" as Date)

user00341

Thank you! This was exactly what I needed.

TDaily

Using the TRUNC function has been the best solution in my experince for this.