Data overflow error while converting dates - Postgresql

Question

I am trying to use an ODBC driver for Postgresql and Powerpivot, however when I try to import the data i get the following error.

Data overflow converting to the data type for table '86b8ef16-cb03-41c6-a076-29fa39c0479b' column 'details_dob'.

The operation has been cancelled.

The error only seems to be when importing dates.

Does anyone have any suggestions?

 

Answer 1

Hi,

Have you tried the option to import the data using a query? You could wrap the details_dob in a "to_char(details_dob, 'mm/dd/yyyy')"

Thanks,

Arul