Using UPDATE statement in Redshift

user084115 · July 2022

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

MichelleH · July 2022

Hi @user084115 try removing the comma after UPDATE "table1"

user084115 · July 2022

Thanks @MichelleH , i tired it, it still didnt work

MichelleH · July 2022

@user084115 I also recommend changing your date format to '2022-01-07'

Magic ETL