mysql查询数据库日期_转载MYSQL查询数据库日期

第一种方法: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 |

+---------------------+


版权声明:本文为weixin_32319177原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。