Time Zones and MySQL
Loading...
Uploaded by tcation on Apr 20, 2010
Sheeri K. Cabral (Pythian) speaks at the 2010 O'Reilly MySQL Conference & Expo.
Slides: http://bit.ly/my10tz
From the official conference description at http://en.oreilly.com/mysql2010/public/schedule/detail/12412
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 servers 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.
- 0 likes, 0 dislikes
-
- 21 videos2010 MySQL User Conference & Expo Sessions
- 57:32
High-throughput MySQLby tcation1,135 views
- 1:18:52
Time Zones in MySQLby tcation519 views
- 1:25:04
MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)by tcation461 views
- 46:00
Find Query Problems Proactively With Query Reviewsby tcation563 views
- 9:59
PHP Tutorial: Timezone Changer Part 1by PHPManTut412 views
- 4:43
Date and Time in PHP - HD tutorialby MonsterProjectsMedia2,069 views
- 2:18
MySQL Tutorial : time stamp commandby MrAmitweb833 views
- 9:22
MySQL to PHP Converting Time Date Timestamp 1 of 4by Beginer2316 views
- 1:40
SQL 014 SELECT DATE, TIME and TIMESTAMPby cbtinc1,319 views
- 11:25
PHP MySQL Tutorial: Create a Database and Table in phpMyAdmin -HD-by RiverCityGraphix107,068 views
- 7:44
PHP display data from MySQL databaseby phpBasics11,599 views
- 9:26
PHP criando um mural de recados parte 5by Fabianowebdeveloper1,399 views
- 1:48
Changed Timezones (The West Wing)by capierno179,712 views
- 6:17
Installing and configuring mysqlby RKJholok6,380 views
- 1:36
SQL 047 Data Types, Approximate Numeric, DOUBLE PRECISIONby cbtinc223 views
- 40:37
Large Deployment Best Practicesby tcation395 views
- 3:01
SQL 052 Data Types, Date, Time and Timestamp Data, Compare Database Usageby cbtinc1,196 views
- 37:53
Using Visual Studio 2010 With MySQLby tcation16,233 views
- 1:22
SQL 055 Data Types, Date Time Timestamp Data, TIME WITH TIME ZONEby cbtinc353 views
- 9:51
MySQL Tutorial 4 - Login Page Exampleby thornwebdesign5,948 views
Link to this comment:
All Comments (0)