MySQL 时间戳(Timestamp)函数
来源:互联网 发布:mac打破折号 编辑:程序博客网 时间:2024/05/24 04:09
http://blog.sina.com.cn/s/blog_645e12550100o6yt.html
- MySQL 获得当前时间戳函数:current_timestamp, current_timestamp()
mysql> select current_timestamp, current_timestamp();
+———————+———————+
| current_timestamp | current_timestamp() |
+———————+———————+
| 2008-08-09 23:22:24 | 2008-08-09 23:22:24 |
+———————+———————+
- MySQL (Unix 时间戳、日期)转换函数:
unix_timestamp(),
unix_timestamp(date),
from_unixtime(unix_timestamp),
from_unixtime(unix_timestamp,format)
下面是示例:
select unix_timestamp(); – 1218290027
select unix_timestamp(‘2008-08-08’); – 1218124800
select unix_timestamp(‘2008-08-08 12:30:00’); – 1218169800
select from_unixtime(1218290027); – ‘2008-08-09 21:53:47’
select from_unixtime(1218124800); – ‘2008-08-08 00:00:00’
select from_unixtime(1218169800); – ‘2008-08-08 12:30:00’
select from_unixtime(1218169800, ‘%Y %D %M %h:%i:%s %x’); – ‘2008 8th August 12:30:00 2008’
- MySQL 时间戳(timestamp)转换、增、减函数:
timestamp(date) – date to timestamp
timestamp(dt,time) – dt + time
timestampadd(unit,interval,datetime_expr) –
timestampdiff(unit,datetime_expr1,datetime_expr2) –
请看示例部分:
select timestamp(‘2008-08-08’); – 2008-08-08 00:00:00
select timestamp(‘2008-08-08 08:00:00’, ‘01:01:01’); – 2008-08-08 09:01:01
select timestamp(‘2008-08-08 08:00:00’, ‘10 01:01:01’); – 2008-08-18 09:01:01
select timestampadd(day, 1, ‘2008-08-08 08:00:00’); – 2008-08-09 08:00:00
select date_add(‘2008-08-08 08:00:00’, interval 1 day); – 2008-08-09 08:00:00
MySQL timestampadd() 函数类似于 date_add()。
select timestampdiff(year,’2002-05-01’,’2001-01-01’); – -1
select timestampdiff(day ,’2002-05-01’,’2001-01-01’); – -485
select timestampdiff(hour,’2008-08-08 12:00:00’,’2008-08-08 00:00:00’); – -12
select datediff(‘2008-08-08 12:00:00’, ‘2008-08-01 00:00:00’); – 7
MySQL timestampdiff() 函数就比 datediff() 功能强多了,datediff() 只能计算两个日期(date)之间相差的天数。
- MySQL 时间戳(Timestamp)函数
- MySQL 时间戳(Timestamp)函数
- MySQL 时间戳(Timestamp)函数
- MySQL 时间戳(Timestamp)函数
- MySQL 时间戳(Timestamp)函数
- MySQL 时间戳(Timestamp)函数
- MySQL 时间戳(Timestamp)函数
- MySQL 时间戳(Timestamp)函数
- mysql TIMESTAMP(时间戳)详解
- mysql TIMESTAMP(时间戳)详解
- mysql TIMESTAMP(时间戳)详解
- mysql TIMESTAMP(时间戳)详解
- MySQL TIMESTAMP(时间戳)详解
- MySQL中timestamp(时间戳)自动更新详解
- mysql之TIMESTAMP(时间戳)用法详解
- mysql之TIMESTAMP(时间戳)用法详解
- mysql之TIMESTAMP(时间戳)用法详解
- mysql之TIMESTAMP(时间戳)用法详解(转载)
- eyesight goodness
- ios 关于UIAlertView与UIActionSheet的区别,以及在使用过程中注意事项
- vss和vs2008搭建源代码管理服务器
- 编程小练习
- rally ---openstack 性能测试
- MySQL 时间戳(Timestamp)函数
- HTTP协议
- Javascript 面向对象编程
- 面向对象三大特性
- 求数据流中的中位数
- WPF Toolkit chart控件
- Shader and Program编程基本概念 - 转
- android API Guides---Device Compatibility
- 项目3——IP地址类