首頁 >資料庫 >mysql教程 >MySQL内置时间curdate查询用法

MySQL内置时间curdate查询用法

WBOY
WBOY原創
2016-06-07 14:53:261645瀏覽

mysql SELECT year(curdate()); +-----------------+ | year(curdate()) | +-----------------+ | 2009 | +-----------------+ 1 row in set (0.00 sec) mysql SELECT month(curdate()); +------------------+ | month(curdate()) | +------------------+

  mysql> SELECT year(curdate());

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

  | year(curdate()) |

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

  | 2009 |

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

  1 row in set (0.00 sec)

  mysql> SELECT month(curdate());

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

  | month(curdate()) |

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

  | 8 |

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

  1 row in set (0.00 sec)

  mysql> SELECT day(curdate());

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

  | day(curdate()) |

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

  | 9 |

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

  1 row in set (0.00 sec)

  mysql> SELECT curdate();

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

  | curdate() |

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

  | 2009-08-09 |

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

  1 row in set (0.00 sec)

  mysql> SELECT dayofmonth(curdate());

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

  | dayofmonth(curdate()) |

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

  | 9 |

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

  1 row in set (0.00 sec)

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn