mysql查系统时间
答案:2 悬赏:50 手机版
解决时间 2021-12-17 16:20
- 提问者网友：當流星隕落
- 2021-12-17 03:39
mysql查系统时间
最佳答案
- 五星知识达人网友：魔法商店永不打烊
- 2021-12-17 05:12
select current_date as Systemtime;
第一种方法：select current_date；
mysql> select current_date as Systemtime;
+------------+
| Systemtime |
+------------+
| 2009-07-29 |
+------------+
第二种方法：select now()
mysql> select now() as Systemtime;
+---------------------+
| Systemtime |
+---------------------+
| 2009-07-29 19:06:07 |
+---------------------+
第三种方法：select sysdate()
mysql> select sysdate() as Systemtime;
+---------------------+
| Systemtime |
+---------------------+
| 2009-07-29 19:06:45 |
+---------------------+
第一种方法：select current_date；
mysql> select current_date as Systemtime;
+------------+
| Systemtime |
+------------+
| 2009-07-29 |
+------------+
第二种方法：select now()
mysql> select now() as Systemtime;
+---------------------+
| Systemtime |
+---------------------+
| 2009-07-29 19:06:07 |
+---------------------+
第三种方法：select sysdate()
mysql> select sysdate() as Systemtime;
+---------------------+
| Systemtime |
+---------------------+
| 2009-07-29 19:06:45 |
+---------------------+
全部回答
- 1楼网友：爱巳過剘
- 2021-12-17 05:20
下载sql-解压-点击安装文件
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯