Shulou(Shulou.com)05/31 Report--

This article introduces you what the MySQL database time types are, the content is very detailed, interested friends can refer to, hope to be helpful to you.

How to physically store the time type of MySQL database

1.timestamp Typ

What is recorded in the row data is a timestamp, four bytes, and converting four bytes of data into integers is a second value starting at 1970.

2.date Typ

Store 3 bytes, for example, if the row records:

(gdb) pbuf [30] $4 "33 miles'(gdb) pbuf [31] $5 million Mexico 73 'cities' (gdb) pbuf [32] $6" 15'\ 017'

Represented as a three-byte binary:

000011111011011100100001

1-5 bits represent the date, 6-9 bits represent the month, and the rest represent the year, so the above date types can be converted to 2011-09-01.

3.year Typ

Record the year, in one byte, starting in 1900

For example

(gdb) pbuf [33] $7 million 112 million p'

Means 112, 1900, 2012.

4.datetime

8-byte representation, for example, input: 2011-08-2719

Then convert it to (256-98) + 3 "256 + (256-74) * 256" 256 "106" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256" 256 "256"

The calculated result is 20110827193246, corresponding to the date entered!

About the MySQL database time type which has shared here, hoped that the above content can have the certain help to everybody, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.