Python date match with MySQL

Question

I have the following code:

fixtures = StraightredFixture.objects.filter(soccerseason=soccerseason,fixturematchday=fixturematchday).order_by('fixturedate')

firstGameTime = str(fixtures[0].fixturedate).split()
currentTime = str(datetime.now().strftime("%Y-%m-%d %H:%M:%S")).split()


if firstGameTime >= currentTime:
    selectteams = True
else:
    selectteams = False

Whatever the date of the firstGameTime is it always returns False. Two examples are as follows:

firstGameTime  = ['2010-10-28', '11:30:00+00:00'] 
currentTime = ['2016-10-29', '10:51:50']
selectteams = False

firstGameTime = ['2010-10-30', '11:30:00+00:00'] 
currentTime = ['2016-10-29', '10:53:16']
selectteams = False

In the second example I would expect it to say True as the firstGameTime is the 30th whereas the currentTime is the 29th.

I have a feeling it is to do with the +00:00 part but am at a loss on how to fix this. Any help would be appreciated, many thanks, Alan.

Why are you converting these to lists of strings for comparison, rather than keeping them as datetimes? — Daniel Roseman, Oct 29 '16 at 10:31
Read it online somewhere as a solution. I don't need to, so any solution is appreciated. — Alan Tingey, Oct 29 '16 at 10:44

score 1 · Accepted Answer · answered Oct 29 '16 at 10:48

1

Datetimes are directly comparable. There is no need to convert to lists of strings.

firstGameTime = fixtures[0].fixturedate
currentTime = datetime.now()

if firstGameTime >= currentTime:
    ...

However, since this is Django you could do this directly in the query:

selectteams = StraightredFixture.objects.filter(
    soccerseason=soccerseason,
    fixturematchday=fixturematchday
    fixturedate__gte=datetime.now()
).exists()

answered Oct 29 '16 at 10:48

Daniel Roseman

588,541
66
880
895

Sadly I am getting the following error: can't compare offset-naive and offset-aware datetimes. – Alan Tingey Oct 29 '16 at 12:22
By using your answer and that help at the following link: http://stackoverflow.com/questions/15307623/cant-compare-naive-and-aware-datetime-now-challenge-datetime-end I got the solution. Many thanks for your help. Could the person who downvoted me the question contact me and help me understand the downvote for future reference. – Alan Tingey Oct 29 '16 at 12:27

Python date match with MySQL

1 Answers1