MySQL the DATE, DATETIME and TIMESTAMP Types
来源:互联网 发布:阿里云企业邮箱登陆 编辑:程序博客网 时间:2024/05/19 20:22
The Date type is used for values with a data part but no time part, MySQL retrieves and displays DATE values in ‘YYYY-MM-DD’ format. The supported range is ‘1000-01-01’ to ‘9999-12-31’.
The DATETIME type is used for values that contains both date and time parts. MySQL retrieves and displays DATETIME values in ‘YYYY-MM-DD HH:MM:SS’ format. The supported range is ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’
The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC
Besides the above three types of TIME TYPE DATA, there is also a TIME type, in ‘HH:MM:SS’ format.
0 0
- MySQL the DATE, DATETIME and TIMESTAMP Types
- The DATE, DATETIME, and TIMESTAMP Types
- mysql datetime,timestamp,date
- mysql Date DateTime TimeStamp
- Mysql------date、datetime、timestamp区别
- DATETIME、DATE和TIMESTAMP类型--MySql数据库
- Mysql date、datetime、timestamp 区别和联系
- mysql的日期类型date, datetime, timestamp
- mysql中datetime、date、timestamp区别
- mysql中date、time、datetime、timestamp区别
- mysql datetime、date、time、timestamp区别
- mysql date and timestamp operations
- TIMESTAMP datetime date
- Date、Datetime、Timestamp
- mysql中DATETIME、DATE 和 TIMESTAMP 类型数据使用
- mysql中DATETIME、DATE 和 TIMESTAMP 类型数据使用
- mysql中DATETIME、DATE和TIMESTAMP的区别
- Mysql 时间类型 DATETIME、DATE和TIMESTAMP类型
- mysql设置外网ip访问
- JDK环境变量设置详解
- win2008R2安装Epson630K共享打印 64位 32位通吃!
- testbench的文件读写
- LintCode-打劫房屋
- MySQL the DATE, DATETIME and TIMESTAMP Types
- javaweb中的验证码实现
- Windows Socket五种I/O模型
- history命令小技巧
- TCP/IP数据包的认识
- 第12周项目1 教师兼干部类
- PowerShell FTP客户端上传下载模块的编写
- MFC 知识 总结(1)
- 初识ant