当前位置:网站首页>Is there a problem with the CURRENT_TIMESTAMP(6) function?
Is there a problem with the CURRENT_TIMESTAMP(6) function?
2022-08-10 12:35:00 【Daming_Database_Commander】
Does the CURRENT_TIMESTAMP(6) function of MYSQL ON UPDATE CURRENT_TIMESTAMP(6) have a 2038 limit like the TIMESTAMP field type, and is there a time zone conversion cost?
Accept answer 1:
There are also limitations;
The experiment sees the truth, I hope it will help you, if you have any help, please click to accept, thank you
Other Answer 1:
There are also limitations;
The experiment sees the truth, I hope it will help you, if you have any help, please click to accept, thank you
Other Answer 2:
I tested with 8.0.Also have this problem.
Other Answer 3:

Screenshot from:
https://www.modb.pro/db/130918
I hope this helps you
Other Answer 4:
In this way, MYSQL 2038 is fully limited
Will there be another time zone conversion operation?
Other Answer 5:


Two experiments again. After changing the system time to 2038, the entire mysql database collapsed. It should be the timestamp used in mysql, which caused mysql to crash.I don't know if other versions have fixed this issue.
I only have version 5.6 now.
Other Answer 6:
Ask whether the CURRENT_TIMESTAMP(6) function of MYSQL ON UPDATE CURRENT_TIMESTAMP(6) has the same time zone conversion cost as the TIMESTAMP field type? For example, the time zone is set to SYSTEM
https://mp.weixin.qq.com/s/AtyaIP92L6KnZFB9bQA3ug
MySQL parameter time_zone causes high online sys cpu
Other Answer 7:
The conclusion of the article clearly states that the partition conversion is caused by time_zone = system.
It is recommended to replace TIMESTAMP with datetime;
Content interception: https://wenku.baidu.com/view/efc469e0b84cf7ec4afe04a1b0717fd5370cb24d.html

边栏推荐
猜你喜欢

太香了!自从用了这款接口神器,我的团队效率提升了 60%!

第5章 虚拟存储器

Network Fundamentals (Section 1)

如何培养ui设计师的设计思维?

Does face attendance choose face comparison 1:1 or face search 1:N?

Does your child lack self-discipline?Ape Counseling: Pay attention to "blank" in the schedule to give children more control

面试美团被问到了Redis,搞懂这几个问题,让你轻松吊打面试官

A detailed explanation of implementation api embed

蚂蚁金服+拼多多+抖音+天猫(技术三面)面经合集助你拿大厂offer

十八、一起学习Lua 调试(Debug)
随机推荐
7、Instant-ngp
What are some useful performance testing tools recommended? Performance testing report charging standards
LeetCode 362. Design Hit Counter
mpf6_Time Series Data_quandl_更正kernel PCA_AIC_BIC_trend_log_return_seasonal_decompose_sARIMAx_ADFull
托米的咒语
three.js blur glass effect
Does face attendance choose face comparison 1:1 or face search 1:N?
三星计划2023年开始在越南生产半导体零部件
【集合】HashSet和ArrayList的查找Contains()时间复杂度
tommy's spell
If someone asks you about distributed transactions again, throw this to him
人脸考勤是选择人脸比对1:1还是人脸搜索1:N?
codevs 2370 Small room tree (LCA)
2016,还是到了最后
基于PLECS的离网(孤岛)并联逆变器的Droop Control下垂控制仿真
孩子自律性不够?猿辅导:计划表要注意“留白”给孩子更多掌控感
Network Fundamentals (Section 1)
堪称神级的阿里巴巴“高并发”教程——基础+实战+源码+面试+架构 全包了
LeetCode 25. A set of K flipped linked lists
LeetCode 109. 有序链表转换二叉搜索树