What is the most accurate way to store date and time inside database that will work on all common database engines?
I want to know:
1. The fields I should create, should I create one field for date and one field for time or one for both
2. The date format
3. The SQL statements that will be used to get data between two dates and also get the date and time information, then convert them to any other format
4. How can I show the date to the member according to THEIR time zone?