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')
请先登录再写评论。