mysql时间转化函数

最新推荐文章于 2024-08-09 15:29:28 发布

ironceo

最新推荐文章于 2024-08-09 15:29:28 发布

阅读量106

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/ironceo/article/details/120602577

版权

涉及函数
date_format(date, format) 函数，MySQL日期格式化函数date_format()
unix_timestamp() 函数
str_to_date(str, format) 函数
from_unixtime(unix_timestamp, format) 函数，MySQL时间戳格式化函数from_unixtime

MySQL [ys_tes1]> select date_format(now(), '%Y-%m-%d');
+--------------------------------+
| date_format(now(), '%Y-%m-%d') |
+--------------------------------+
| 2021-10-04                     |
+--------------------------------+
1 row in set (0.00 sec)

MySQL [ys_tes1]> 
MySQL [ys_tes1]> 
MySQL [ys_tes1]> --时间转字符串
MySQL [ys_tes1]> select date_format(now(), '%Y-%m-%d');
+--------------------------------+
| date_format(now(), '%Y-%m-%d') |
+--------------------------------+
| 2021-10-04                     |
+--------------------------------+
1 row in set (0.00 sec)

MySQL [ys_tes1]> --时间转时间戳
MySQL [ys_tes1]> select unix_timestamp(now());    
+-----------------------+
| unix_timestamp(now()) |
+-----------------------+
|            1633319027 |
+-----------------------+
1 row in set (0.00 sec)

MySQL [ys_tes1]>  
MySQL [ys_tes1]> --字符串转时间
MySQL [ys_tes1]> select str_to_date('2021-10-04', '%Y-%m-%d %H');  
+------------------------------------------+
| str_to_date('2021-10-04', '%Y-%m-%d %H') |
+------------------------------------------+
| 2021-10-04 00:00:00                      |
+------------------------------------------+
1 row in set (0.00 sec)

MySQL [ys_tes1]> 
MySQL [ys_tes1]> --字符串转时间戳
MySQL [ys_tes1]> select unix_timestamp('2021-10-04');  
+------------------------------+
| unix_timestamp('2021-10-04') |
+------------------------------+
|                   1633276800 |
+------------------------------+
1 row in set (0.00 sec)

MySQL [ys_tes1]> 
MySQL [ys_tes1]> --时间戳转时间
MySQL [ys_tes1]> select from_unixtime(1633276800);  
+---------------------------+
| from_unixtime(1633276800) |
+---------------------------+
| 2021-10-04 00:00:00       |
+---------------------------+
1 row in set (0.00 sec)

MySQL [ys_tes1]> --时间戳转字符串
MySQL [ys_tes1]>  select from_unixtime(1633276800,'%Y-%d');  
+-----------------------------------+
| from_unixtime(1633276800,'%Y-%d') |
+-----------------------------------+
| 2021-04                           |
+-----------------------------------+
1 row in set (0.00 sec)

MySQL [ys_tes1]> 
MySQL [ys_tes1]>