当前位置:网站首页>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
边栏推荐
- Dining (web stream)
- 解决 idea 单元测试不能使用Scanner
- 48 the mysql database
- LeetCode 445. 两数相加 II
- 蚂蚁金服+拼多多+抖音+天猫(技术三面)面经合集助你拿大厂offer
- Data Analysis of Time Series (5): Simple Prediction Method
- CV复习:空洞卷积
- leetcode/两个链表的第一个重合节点
- Analysis of the implementation principle of UUID from the perspective of source code
- CLIP还能做分割任务?哥廷根大学提出一个使用文本和图像prompt,能同时作三个分割任务的模型CLIPSeg,榨干CLIP能力...
猜你喜欢
StarRocks on AWS 回顾 | Data Everywhere 系列活动深圳站圆满结束
可视化服务编排在金融APP中的实践
太香了!自从用了这款接口神器,我的团队效率提升了 60%!
dedecms支持Word内容一键导入
So delicious!Since using this interface artifact, my team efficiency has increased by 60%!
Crypto Gaming: The Future of Gaming
你是怎么知道数据库 Htap 能力强弱的?怎么能看出来
百度用户产品流批一体的实时数仓实践
解决 idea 单元测试不能使用Scanner
自定义过滤器和拦截器实现ThreadLocal线程封闭
随机推荐
Samsung plans to start producing semiconductor components in Vietnam in 2023
你有一份斗破苍穹词库,请查收
Ssm framework construction process [easy to understand]
自定义过滤器和拦截器实现ThreadLocal线程封闭
Configure druid data source "recommended collection"
jlink 与 swd 接口定义
一文详解 implementation api embed
LeetCode 369. Plus One Linked List
HDU 4135: Co-prime (the principle of inclusion and exclusion)
堪称神级的阿里巴巴“高并发”教程——基础+实战+源码+面试+架构 全包了
面试官:你们是如何保证接口的幂等性?
LeetCode 362. Design Hit Counter
传三星3nm斩获第二家客户,目前产能已供不应求
LeetCode 109. 有序链表转换二叉搜索树
LeetCode 86. Delimited Linked List
An enhanced dynamic packet buffer management. The core part of the paper
阿里云贾朝辉:云XR平台支持彼真科技呈现国风科幻虚拟演唱会
Excel function formulas - HLOOKUP function
Excel函数公式大全—LOOKUP函数
人脸考勤是选择人脸比对1:1还是人脸搜索1:N?