Acquiring a basic understanding of the Joomla! database structure would not be complete without a discussion on how to work with dates, formatted data, and multi-byte character sets.
We regularly use
datetime data type to record the date and time at which an action has taken place. When we use these fields, it is important that we are aware of the effect of time zones. All dates and times should be recorded in UTC+0 (GMT / Z).
Different database servers use different date and time formats to store dates and times. It is important that we save dates and times using the appropriate format. Unfortunately, there is currently no way to ensure that we are using the correct format. This forces us to assume that the database ...