Answer by ThomasRushton ·
Ye gods, why? Why would you do this? Store dates as dates, and then you don't run into these problems, and deal with formatting in the presentation layer.
Apart from anything else, you'll get better response times, save space, and not be tied to a brain-dead middle-endian date format. ISO8601 FTW.
Created a simple table that adds up points scored per player per game, however I don't know what to do if a player didn't play in one of the games. Null seems to add a 0 value, which renders my calculations incorrect. Help, please.