CODEWITHSUNDEEP
amazon-web-servicesamazon-redshift
Hello lad
Hello lad

Reputation: 18790

Timestamp with time zone in Redshift

encountered this error when copying data, which is just unloaded from one redshift table, into another redshift table

Invalid timestamp format or value [YYYY-MM-DD HH24:MI:SS]

the data entry is:

2016-07-07T14:17:57.360+02:00

How could I solve it?

Hard to image unload the data and can not load it back again on Redshift.

Upvotes: 2

Views: 4125

Answers (2)

Nicolas G
Nicolas G

Reputation: 123

We had a similar issue, and using TIMEFORMAT 'auto' did not solve it.

This answer to a similar question explains a workaround using an intermediate table with a varchar field

Upvotes: 0

Steve S
Steve S

Reputation: 136

Try adding the TIMEFORMAT 'auto' to your load parameters.

See the docs for more info.

Upvotes: 1

Related Questions