MySQL Essential Training: Date and Time Types


show more Date and time types provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training show less
please wait ...

Date and time types

MySQL supports a complete set of date and time types. These include date, time, a standalone year type, a combined datetime type, and a timestamp type that's automatically updated when a row is created or updated. It's worth noting that two digit year support is deprecated as of MySQL 5.6.6. It still works according to these rules. But the documentation warns that this functionality will be removed in a future release.

Keep in mind that two digit years are never a good idea, and if you're using them today, you'll be well served by updating your systems to use four digit years. My sql stores dates and times in standard sql format. Standard sql format for dates and times is designed for convenient sorting and searching. Different countries and locals have different localized formats for dates and times. Some with the year to the left some with the year to the right. Some in odd mixed up orders like the month day year format common in the US.

Standard SQL format has the most significant pa...

Date and time types
Video duration: 7m 2s 4h 24m Beginner

Viewers:

Date and time types provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training

Subject:
Developer
Software:
MySQL
Author:
please wait ...