Date and time

As mentioned, the preferred way to store dates in MySQL when working with PHP is to use Unix timestamps - large integers. However, this is not always the case - for example, if you use MySQL timestamps, you are able to make use of a wide variety of special functions within MySQL to help you work with dates, just as with PHP.

This advantage is minimal, however, because MySQL can convert from Unix timestamps as appropriate, so unless you are working with a database that will be read from a location not able to handle Unix timestamps - for example if you will be reading from it using PHP and Visual Basic for Windows, which cannot handle Unix timestamps - then you might want to use formatted dates.

 

Want to learn PHP 7?

Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!

If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: Transactions >>

Previous chapter: Types of data

Jump to:

 

Home: Table of Contents

Copyright ©2015 Paul Hudson. Follow me: @twostraws.