Skip to Main Content
MySQL 8 Administrator???s Guide
book

MySQL 8 Administrator???s Guide

by Chintan Mehta, Hetal Oza, Subhash Shah, Ravi Shah
February 2018
Intermediate to advanced content levelIntermediate to advanced
510 pages
16h 10m
English
Packt Publishing
Content preview from MySQL 8 Administrator???s Guide

DATE, DATETIME, and TIMESTAMP types

This section describes the most commonly used MySQL date and time data types: DATE, DATETIME, and TIMESTAMP. This section explains the similarities and differences between these data types.

The DATE data type is suitable when the values we wish to store have a date part, but the time part is missing. The standard MySQL date format is YYYY-MM-DD. The date values are retrieved and displayed in the standard format unless DATE functions are applied. The MySQL supported range of values is 1000-01-01 to 9999-12-31. Supported, here, means the values may work, but there is no guarantee. The same is the case for the DATETIME data type.

The DATETIME data type is suitable for values containing date and time parts. ...

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.
Start your free trial

You might also like

Hands-On MySQL Administration

Hands-On MySQL Administration

Arunjith Aravindan, Jeyaram Ayyalusamy
SQL Cookbook, 2nd Edition

SQL Cookbook, 2nd Edition

Anthony Molinaro, Robert de Graaf

Publisher Resources

ISBN: 9781788395199Supplemental Content