Unanswered: DateTime or TimeStamp or UnixTimeStamp ?
Let me give you my example:
I need to manage a shared calendar with the ability
to create/update/remove sessions containing among other info
- the location
- the owner
- the date
- the time_from time_to
And I'll need to supply reports with sums of hours (or day counting)
grouped by whatever info
I'm wondering how am I going to store date&time, here are my solutions:
The question: is what is the best format ?
I'd like to know the pros/cons for these 3 choices.
Or do you have another option ?