Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.The MySQL FROM_UNIXTIME() function does not support negative epoch timestamps, it returns NULL. This SQL function is used in the date filter handler, which means you cannot filter on dates prior to Jan 1st 1970.
The problem can be solved by using the DATE_ADD function, as has been done in the patch.
| Comment | File | Size | Author |
|---|---|---|---|
| filter_dates_prior_1970.patch | 461 bytes | inascon |
Comments
Comment #2
Alexandre360 commentedConfirm the issue, and confirm the fix.
Should be commited ASAP cause it's a serious issue for all people dealing with date prior to 1970.
Comment #3
damienmckennaThanks for the patch, we'll try to review it soon.
BTW when you upload a patch it helps to set the status to "needs review", that triggers the testbots and lets others know that there's something review.
Comment #4
damienmckennaI think we need test coverage to make sure this works as expected.