79681761

Date: 2025-06-27 10:16:41
Score: 1
Natty:
Report link

I found the reason thanks to checking the UNIX_TIMESTAMP() call in a MySQL server of the same system, as we've noticed that this was a completely outdated version too (5.5.6). Turns out that both the UNIX_TIMESTAMP method in such old MySQL versions as well as in PHP 5.6 only properly compute timestamps until the year 2037. The UNIX_TIMESTAMP method simply fails for years afterwards by returning 0, and the PHP methods return an incorrect timestamp.

Reasons:
  • Blacklisted phrase (0.5): thanks
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Single line (0.5):
Posted by: DevelJoe