花美男为中国互联网事业而奋斗

MySQL Date Functions

来源:未知 阅读(0)次 评论(0)

 The most difficult part when working with dates is to be sure that the format of the date you are trying to insert, matches the format of the date column in the database.

MySQL Date Functions

The following table lists the most important built-in date functions in MySQL:

FunctionDescription
NOW()Returns the current date and time
CURDATE()Returns the current date
CURTIME()Returns the current time
DATE()Extracts the date part of a date or date/time expression
EXTRACT()Returns a single part of a date/time
DATE_ADD()Adds a specified time interval to a date
DATE_SUB()Subtracts a specified time interval from a date
DATEDIFF()Returns the number of days between two dates
DATE_FORMAT()Displays date/time data in different formats


标签:
上一篇:PHP无限级分类 下一篇:MySQL DATEDIFF() Function

相关推荐