Re: Backend bod: "Either way is fine"
it should be stored as ISO-8601 and translated in the UI
Worst of at least two worlds. Store it as a regular timestamp, then use standard libraries (and locale settings) to present it. In the unlikely event that you have a system that still has a 32-bit time_t, either document it ("recompile before 2038") or grab a library with 64 bits.
These days there's no excuse to mess up date&time: any mainstream environment will provide standard library functions to deal with them. Broken or other nonstandard timedate should only be seen in those legacy systems that didn't get cleaned up in the Y2K purges.
Biting the hand that feeds IT
