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?
0
Best 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
-
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 -
Thank you! This was exactly what I needed.
1 -
Using the TRUNC function has been the best solution in my experince for this.
1
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有