Inserting String

Hi all,

I am trying to insert numbers as  string  from excel in format '000-000-000' in to aginity redhsift database using sqlalchemy

I am using pycharm 2017.1.3, also tried below code.

# pd.Series.to_string(data['Code'])

Below is the error I am receiving , Urgent please help.

sqlalchemy.exc.DataError: ('(psycopg2.DataError) date/time field value out of range: "053-999-000"\nHINT:  Perhaps you need a different "datestyle" setting.\n', u'occurred at index 0')


Please sign in to leave a comment.