Redshift Date & Time to Date Syntax

user00341 · April 2017

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 · April 2017

Casting usually works fairly well for true Datetime columns.

Example:

Cast("Datetime Column" as Date)

AS · April 2017

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

user00341 · April 2017

Thank you! This was exactly what I needed.

TDaily · April 2018

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

Best Answer