what is invalid literal for int() with base 10: 'startTime'

Asked Jul 07 '20 at 13:41

Active Jul 07 '20 at 13:41

Viewed 75 times

i am getting an error of invalid literal for int() with base 10: 'startTime'

 hour=datetime.datetime.fromtimestamp((int(str('startTime')))/1000).strftime('%H')

startTime is Integerfield in my model which contains 13 digit unix timestamp this is my query code

 timehour = InteractionWith.objects.values(
    #hour=ExtractHour('startTime')
    hour=datetime.datetime.fromtimestamp((int(str('startTime')))/1000).strftime('%H')
).annotate(
    times=Count('pk')
).order_by('hour')

asked Jul 07 '20 at 13:41

Vivek Anand

``'startTime'`` is a string; it does not refer to nor access any field of an object or database. – MisterMiyagi Jul 07 '20 at 13:47
how should i make it refer to my django model field – Vivek Anand Jul 07 '20 at 13:49
what is wrong with `ExtractHour`? – ktowen Jul 07 '20 at 14:38
it doesnt work as my startTime is a integerfield and also i tried it in cmd prompt readable=ExtractHour((1593169750)) , print (readable) output was ExtractHour(Value(1593169750)) – Vivek Anand Jul 07 '20 at 14:41

what is invalid literal for int() with base 10: 'startTime'

0 Answers0