Database MySQL content supplement

MySQL Time function--Get Current dateSelectcurrent_date ();--Get current TimeSelectcurrent_time ();--gets the current date and timeSelectNow ();--get datetime year, month, daySelectYear (now ());--yearsSelectMonth (now ());--MonthSelectDay (now ());--days--returns the date portion of a datetimeSelectDate (now ());--Add date or time to datetimeSelectDate_add (now (), interval1Day);--the day after the current datetimeSelectDate_add (now (), Interval-1Day);--the day before the current datetimeSelectDate (Date_add (), Interval-1Day));--date of the day before the current datetimeSelectDate_add (now (), interval1month);--one months after the current datetimeSelectDate_add (now (), interval1year);--the latter of the current datetime

Database MySQL content supplement