-
DATEDIFF() : -
DATEDIFF(end_date,start_date) -
WEEKDAY()/DAYOFWEEK() : -
WEEKDAY(date,mode)(mode like 0 : Sunday (default), 1 : Monday, 2 : Saturday). -
TIMESTAMPDIFF() : -
TIMESTAMPDIFF(unit,dtime1,dtime2)(unit like SECOND, MINUTE, HOUR, DAY) -
MONTH() : -
MONTH(date) -
DATEPART() : -
DATEPART(part,date)(part like Year, Month, Day) -
DATE_SUB() : -
DATE_SUB(date, interval)(interval likeINTERVAL 5 DAY) -
DATE_FORMAT() : -
DATE_FORMAT(date, format)(format like- '%Y-%m'`: - 2023-01 , 2023-02.....
- '%y-%m'`: - 23-01, 23-02.....
-
STR_TO_DATE() : -
STR_TO_DATE(string, format)'%Y'Year (4 digits)'%y'Year (2 digits)'%m'Month (2 digits)'%d'Day of Month (2 digits)