Using UPDATE statement in Redshift
Hi ,
I am trying to update a column in Redshift using UPDATE statement. But I am getting error
If someone can suggest whats wrong with the code
I tried this code-
UPDATE "table1",
SET "created_dt" = '01/07/2022'
where "change_hint" = 'update'
The output comes as - Whoops ! Something went wrong
0
Answers
-
Hi @user084115 try removing the comma after UPDATE "table1"
0 -
Thanks @MichelleH , i tired it, it still didnt work
0 -
@user084115 I also recommend changing your date format to '2022-01-07'
0
Categories
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 464 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive