Projects, Applications, and API development.
- Posts: 2
- Joined: Sat Mar 28, 2020 10:38 pm
I see many, many games have a release date of "1970-01-01" (this is the placeholder date in the new game form, and is equal to timestamp 0, which is a valid timestamp)
* For "unknown dates" the database should store "0000-00-00" (or null)
* Make the release date field mandatory (without placeholder value) in the "new game form". If unknown, allow a checkbox to explicitly set it to 0000-00-00 / null
- Posts: 324
- Joined: Fri Apr 20, 2018 9:18 am
1970-01-01 is also know as epoch time, its the day epoch time started, that time represent the zeroth second, its the time system used by all modern system (and even ancient systems actually)
because of that, I dont think we can just set the time to 0000, since that would technically be negative time.
however, we could add an option in the statistics page that return games with date set to 1970-01-01