Thank you Stephen, Johnf, This is what I did and it worked :-
todayTime2 = datetime.datetime.now() todayTime1 = timezone('Asia/Calcutta').localize(todayTime2) time_created=%s WHERE group_code = %s;""", ( .....,...,..., str(todayTime1),....)) Thanks for the Hint, Johnf :) Nitin On 1 June 2016 at 18:53, john <jo...@jfcomputer.com> wrote: > cursor1.execute("""UPDATE employee SET > name=%s, > add=%s, > add1=%s, > city=%s, > state_county=%s, > country=%s, > basic=%s, > WHERE group_code = %s""" % > (name,add,add1,city,state_county,country,basic,grpCode)) > > It appears that you are not required to provide any time or date since you > created a default. Of course that assumes you want today and now. > > If that assumption is wrong then lookup "datetime". To make life a little > easier lookup the module "dateutil". You would use either of those modules > to convert your python input to the correct output for postgres (actually > for any sql database). > > Hint: if the field requires a string you should place quotes around the > placeholder as in '%s'. > > Johnf > > > > > _______________________________________________ > Tutor maillist - Tutor@python.org > To unsubscribe or change subscription options: > https://mail.python.org/mailman/listinfo/tutor _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor