如何将日期时间值存储在mysql中? [英] How datetime values are stored in mysql?

问题描述

我是数据库世界的新手.我正在从Java程序发送日期时间值，例如"2016-04-27 09:00:00"，以将其保存到mysql数据库中.我的问题是，如何将此值保存到mysql db表中的datetime类型的字段中.我的意思是，无论是将其存储为我已经通过的字符串，还是mysql都会解析该字符串，并从中构造UTC时间戳并将该数字存储到db中.而且，无论mysql服务器和java服务器的时区设置如何，都可以从java程序中按原样检索此存储的值吗?

I am new to db world. I am sending a datetime value such as '2016-04-27 09:00:00' from java program, for getting it saved into mysql database. My question is that How will this value be saved into datetime type of field in mysql db table. I mean, whether It'll be stored as string as I have passed or mysql will parse the string, and constructs UTC timestamp out of it and store that number into db. Moreover, Will this stored value be retrieved as it is from java program, irrespective of different timezone settings of mysql server and java server ?

很抱歉提出这样一个愚蠢的问题，但是在互联网上搜索时，这让我非常痛苦，而且没有得到简单且不太混乱的答案.

Sorry for such a silly question, but It's hurting me a lot and didn't get simple and less confusing answer, while searching over internet.

推荐答案

来自非小数部分的DATETIME编码:

DATETIME encoding for nonfractional part:

 1 bit  sign           (1= non-negative, 0= negative)
17 bits year*13+month  (year 0-9999, month 0-12)
 5 bits day            (0-31)
 5 bits hour           (0-23)
 6 bits minute         (0-59)
 6 bits second         (0-59)
---------------------------
40 bits = 5 bytes

这篇关于如何将日期时间值存储在mysql中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！