Using UPDATE statement in Redshift

user084115 · 2022-07-01T11:18:02+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

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

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

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