O'Reilly logo

Mastering Joomla! 1.5 Extension and Framework Development by Chuck Lanham, James Kennard

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Additional points to consider

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.

Dates

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required