We just found out that in the database birthday field, all dates has 1-day difference than what is shown on the front-end.

On the front-end, it is the correct date by the way.

Question: Is it a bug and if not, why is this?


The database will be storing the date as seconds since 1970 (epoch) and your view on that is not localised. However, the front end date is localised for your time zone.

Of this I am more sure than that the sun will rise tomorrow (thanks to a recent rise in right wing politicians).

  • That is an excellent suggestion, Jeremy. I will dive into this to see if you are right. Jun 1 '17 at 13:15
  • This answer is 100% correct. I recommend updating it to add more confidence. ;)
    – Lindsey D
    Jun 1 '17 at 16:09
  • Hah - lol, done! Jun 1 '17 at 22:27
  • Yes, it works perfect Jeremy :) I was out celebrating this solution, that's why I could not telling you before ;) Jun 9 '17 at 19:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.