August 2022
Intermediate to advanced
974 pages
26h 5m
English
Content preview from MySQL Cookbook, 4th EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 8. Working with Dates and Times
8.0 Introduction
MySQL has several data types for representing dates and times, and many functions for operating on them. MySQL stores dates and times in specific formats, and it’s important to understand them to avoid surprises in results from manipulating temporal data. This chapter covers the following aspects of working with date and time values in MySQL:
- Choosing a temporal data type
MySQL provides several temporal data types to choose from when you create tables. Knowing their properties enables you to choose them appropriately.
- Displaying dates and times
MySQL displays temporal values using specific formats by default. You can produce other formats by using the appropriate functions.
- Changing the client time zone
The server interprets
TIMESTAMPandDATETIMEvalues in the client’s current time zone, not its own. Clients in different time zones should set their zone so that the server can properly interpretTIMESTAMPvalues for them.- Determining the current date and time
MySQL provides functions that return the date and time. These are useful for applications that must know these values or need to calculate other temporal values in relation to them.
- Tracking row modification times
The
TIMESTAMPandDATETIMEdata types have special properties that enable you to record row-creation and last-modification times automatically.- Breaking dates and times into component values and creating dates and times from component values
You can split date and time values ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.