Best format to save date?

[eluser]cahva[/eluser]
Backend database doesnt really matter if you use TIMESTAMP (YYYY-MM-DD HH:II:SS) which is supported in majority of databases. In any way, exporting the database to other backend is not a job you have to worry about very often and even if you do, datetime type of field can be easily formatted any way you want.

And what about limitations of unix timestamp? You cant save dates before 1970 so thats a bitch when you have a database table with elder people with birthdates Also that daterange ends also in 2038 (at the time of writing ).