Redshift Date & Time to Date Syntax

user00341 Member

April 2017 in Connectors

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? 

0

Best Answer

• 

  PodiumMason Contributor

  April 2017 Answer ✓

  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)

  **Say 'Thanks' by clicking the thumbs up in the post that helped you.
  **Please mark the post that solves your problem as 'Accepted Solution'

  1

Answers

• 

  AS Coach

  April 2017

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

   

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

  Aaron
  MajorDomo @ Merit Medical
  
  **Say "Thanks" by clicking the heart in the post that helped you.
  **Please mark the post that solves your problem by clicking on "Accept as Solution"

  2
• 

  PodiumMason Contributor

  April 2017 Answer ✓

  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)

  **Say 'Thanks' by clicking the thumbs up in the post that helped you.
  **Please mark the post that solves your problem as 'Accepted Solution'

  1
• 

  user00341 Member

  April 2017

  Thank you! This was exactly what I needed.

  1
• 

  TDaily Contributor

  April 2018

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

  Thank you
  TDaily

  1