date expression in python to load into vertica
Posted: Thu Apr 04, 2013 6:57 pm
Hi, Iam trying to update a vertica database table using python script. One of the input date column is in datatype int and need to converted to datatype date. I tried some convertion functions like datetime.strtp, time.strtp but nothing worked. Iam using python 2.4 version and it doesnt have strtp in datetime module. Can anyone suggest how should i need to give the expression for dates.