Thank you very much for all the answers.
Just keep in mind the right order to store a date and time in a database. That is critical and I have no sign from you that you actually now know why?
Enlighten us... Otherwise we keep trying...
Plz show us some "homework", any age accepted, and try to explain if you really understand it now! I am not quite sure.
In your own words please;
1. How do you store date and time in a database in the correct order?
2. Why is that order important?
3. Explain UTC and why it is important
4. Why do display time and UTC time differ almost always? Where not?
5. (easy) Why do you never store date and time as local time?
6. Why do we store date and time as a real? (Maybe programming language differences, in Pascal it is a double.)
You can win a bottle of booze with the correct answers. Just P.M. me.
Only Pe3s,
not you lot!