Sheeri K. Cabral

The Pythian Group

Time Zones and MySQL
20 minutes, 9.3mb, recorded 2010-04-14
Sheeri K. Cabral

At the MySQL Conference, Sheeri K Cabral dives into an explanation of how time is encoded in MySQL and lists the components available: dates, times and times stamps, but not time zones. A majority of the lecture then focuses on how to specify the date within those constraints.

Parts of the lecture also center around writing codes, and specific applications that relate to time - how to convert data, what to do with Daylight Savings Time, and how to make sure the date remains the same regardless of the time zone in which information is saved.

This lecture is practical, applicable, and shows how to manipulate code to allow for better usage of the MySQL data systems and presents the basics of code that can be used for a multitude of other purposes.


Sheeri K. Cabral has a master's degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; she has worked with Oracle, Sybase, DB2, SOlaris, RedHat/Fedora, AIX, and HP-UX. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, USA, MySQL User group, and wrote the MySQL Administrator's Bible.

Resources:

This free podcast is from our MySQL Conference series.

For The Conversations Network:

Photo: Flickr