Join Bill Weinman for an in-depth discussion in this video Time zones in MySQL, part of MySQL Essential Training (2014).
…Mysql provides time zone support on a number of different levels, for…most purposes you'll only be interested in the session time zone setting.…Please note that this lesson requires time zone support is installed on your system.…If you have not installed time zone support for…your system, the exercises in this lesson will not work.…For this lesson, we're not going to be selecting a database,…we're going to be setting some variables and using time stamps.…So for example, we're just going to start with show variables like,…and in single quotes %time_zone% single quote and…semi-colon, and this will show us the time zone related variables in the system.…
You notice that the system time zone is set to the time zone of this machine,…which is in Mountain Standard Time, and the…time zone variable itself is set to UTC.…Now if you don't see UTC there, if you see system or something else,…it probably means that you do not…have times and support installed on your system.…SID sets this variable to UTC, so it should say UTC here.…
- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
1. Installing and Configuring the Test Environment
2. Basic Syntax
3. Creating a Database
4. MySQL Data Types
5. MySQL Functions
8. Subselects and Views
9. Stored Routines
10. PHP's PDO Interface with MySQL
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.