Error Message: One of the identified items was in an invalid format.

Error "One of the identified items was in an invalid format" was received.

Workbench can only process dates within a valid .Net DateTime type range of values, that is from 00:00:00.0000000 UTC, January 1, 0001 to 23:59:59.9999999 UTC, December 31, 9999.  You will see this error if you have data values outside this range like dates containing BC.

Workaround(s)

Use cast to convert the dates into strings.  For example "select my_date::varchar(30) from <table name>"

Affected Version(s)

Workbench for Redshift (all versions)

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk