Mysql Datetime Tutorials

MYSQL Date And Time Types

Tags: Mysql Data Types, Mysql Time, Mysql Date, Mysql Datetime, Mysql Timestamp, Mysql Year

This tutorial will help you to understand about “MYSQL Date and Time Data Types”. Storage Required For Date And Time TypesYEAR TypeTIME TypeDATE, DATETIME AND TIMESTAMP TypeStorage Requirements for Date and Time TypesTIME, DATETIME, TIMESTAMP storage details showed in following table.Data TypeStorage RequiredYEAR1 byteDATE3 byteTIME3 byteDATETIME8 byteTIMESTAMP4 byteYEAR TypeThe default year type is 1 byte type is used to represent year values. It can be declared as YEAR(4) or YEAR(2). […]... Read More »