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.

data['Code']=data['Code'].astype('S')
# pd.Series.to_string(data['Code'])
#data['Code'].astype(str)

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.