mysql datetime timestamp比较
来源:互联网 发布:淘宝网络司法拍卖平台 编辑:程序博客网 时间:2024/05/18 12:01
TIMESTAMP : Very importan it stores the number of milliseconds that have been elapsed Since
1st January 1970 GMT.
1)When you are inserting a DATE value into the MYSQL TIMESTAMP
TIMESTAMP values are converted from the current time zone to UTC for storage,(i.e it will store the number of milliseconds elapsed from
1st January 1970) and converted back from UTC to the current time zone for retrieval.
(This occurs only for the TIMESTAMP data type, not for other types such as DATETIME.
2) Timestamp has some specific qualities (ie.)
The first timestamp field in the database is automatically intialized and update with the current time
on every update of the row.
For More details See Please see : http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
3) Time stamp value is stored in 4 bytes
4) The range of values that this TIMESTAMP will store is very limited.(1970 to 2037)
DATETIME : 1) 8 bytes storage
2) Just stores what you have stored and retrieves the same thing which you have stored.
3) It has nothing to deal with the TIMEZONE and Conversion.
- mysql datetime timestamp比较
- mysql 中的datetime和timestamp的比较
- mysql 中的datetime和timestamp的比较
- MySQL中的datetime与timestamp比较
- 【转】MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- mysql中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp比较
- 【整理】MySQL中的datetime与timestamp比较
- MySQL中的datetime与timestamp区别比较
- php继承访问控制
- 推荐一款很好用的调试JS的Eclipse插件
- GCC Coverage代码分析-GCC插桩基本概念及原理分析
- TCP滑动窗口
- 查询联系人电话
- mysql datetime timestamp比较
- [转]Using CMIS query in Content Query navigation model
- iPhone的解锁、越狱、激活、固件等等是什么意思,有什么分别?
- poj1659 Frogs' Neighborhood(Havel-Hakimi定理)
- c++文件操作
- android的logcat详细用法
- 关于做android+J2ee系统集成开发的一点心得
- JMAIL发邮件
- LED显示屏串口通信