mysql日期时间函数(常用的)

mysql>SELECT NOW(); #返回（打印）当前日期和时间

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

| NOW() |

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

| -03-28 17:53:34 |

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

1 row in set (0.01 sec)

mysql>SELECT CURDATE();#返回（打印）当前日期

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

| CURDATE() |

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

| -03-28 |

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

mysql>SELECT CURTIME();#返回（打印）当前时间

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

| CURTIME() |

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

| 17:55:57 |

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

1 row in set (0.00 sec)

mysql> SELECT DATE_ADD('-3-12', INTERVAL 365 DAY); #日期变化

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

| DATE_ADD('-3-12', INTERVAL 365 DAY) |

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

|-03-12|

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

1 row in set (0.00 sec)

mysql> SELECT DATE_ADD('-3-12', INTERVAL -365 DAY);

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

| DATE_ADD('-3-12', INTERVAL -365 DAY) |

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

|-03-12|

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

1 row in set (0.00 sec)

mysql> SELECT DATE_ADD('-3-12', INTERVAL1 YEAR);

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

| DATE_ADD('-3-12', INTERVAL 1 YEAR) |

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

| -03-12 |

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

1 row in set (0.00 sec)

mysql> SELECT DATE_ADD('-3-12', INTERVAL3 WEEK);

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

| DATE_ADD('-3-12', INTERVAL 3 WEEK) |

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

| -04-02 |

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

1 row in set (0.00 sec)

mysql> SELECTDATEDIFF('-3-12','-3-12'); #日期差值

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

| DATEDIFF('-3-12','-3-12') |

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

| -365 |

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

1 row in set (0.01 sec)

mysql> SELECTDATE_FORMAT('-3-2', '%m/%d/%Y'); #日期格式化

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

| DATE_FORMAT('-3-2', '%m/%d/%Y') |

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

| 03/02/ |

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

1 row in set (0.00 sec)