Time Zones and MySQL

Sheeri K. Cabral (Mozilla Foundation)
Presentation: Time Zones and MySQL Presentation [PDF]
Average rating: ***..
(3.00, 1 rating)

MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone? The TIMESTAMP data type will show different times if you change the server’s time zone. This workshop covers all this and more, including all the nuances of using offsets (such as “-8:00” to represent Pacific Standard Time as UTC -8 hours) and how to use named time zones (such as “US/Eastern”). This presentation is a must for anyone who wants to learn the most optimized way to convert a time based on time zone.

Photo of Sheeri K. Cabral

Sheeri K. Cabral

Mozilla Foundation

Sheeri K. Cabral has a master’s degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; 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 (www.tinyurl.com/mysqlbible). She currently works for PalominoDB, a remote database management company

Comments on this page are now closed.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/21/2010 6:05am PDT

The video for this session is online at www.youtube.com/watch?v=fp-...

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/20/2010 2:47pm PDT

The video for this session is online at www.youtube.com/watch?v=fp-...

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/19/2010 7:55am PDT

Slides are at: bit.ly/my10tz

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.