Example
Format a date:
SELECT DATE_FORMAT("2017-06-15", "%Y");
Definition and Usage
The DATE_FORMAT() function formats a date as specified. Continue reading MySQL DATE_FORMAT Function
MySQL DATE_ADD Function
Example
Add 10 days to a date and return the date:
SELECT DATE_ADD("2017-06-15", INTERVAL 10 DAY);
Definition and Usage
The DATE_ADD() function adds a time/date interval to a date and then returns the date. Continue reading MySQL DATE_ADD Function
MySQL DATEDIFF Function
Example
Return the number of days between two date values:
SELECT DATEDIFF("2017-06-25", "2017-06-15");
Definition and Usage
The DATEDIFF() function returns the number of days between two date values. Continue reading MySQL DATEDIFF Function
MySQL DATE Function
Example
Extract the date part:
SELECT DATE("2017-06-15");
Definition and Usage
The DATE() function extracts the date part from a datetime expression.
Syntax
DATE(expression)
MySQL CURTIME Function
Example
Return current time:
SELECT CURTIME();
Definition and Usage
The CURTIME() function returns the current time.
Note: The time is returned as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
MySQL CURRENT_TIMESTAMP Function
Example
Return the current date and time:
SELECT CURRENT_TIMESTAMP();
Definition and Usage
The CURRENT_TIMESTAMP() function returns the current date and time.
Note: The date and time is returned as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric). Continue reading MySQL CURRENT_TIMESTAMP Function
MySQL CURRENT_TIME Function
Example
Return current time:
SELECT CURRENT_TIME();
Definition and Usage
The CURRENT_TIME() function returns the current time.
Note: The time is returned as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
MySQL CURRENT_DATE Function
Example
Return the current date:
SELECT CURRENT_DATE();
Definition and Usage
The CURRENT_DATE() function returns the current date.
Note: The date is returned as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
MySQL CURDATE Function
Example
Return the current date:
SELECT CURDATE();
Definition and Usage
The CURDATE() function returns the current date.
Note: The date is returned as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
MySQL ADDTIME Function
Example
Add 2 seconds to a time and return the datetime:
SELECT ADDTIME("2017-06-15 09:34:21", "2");
Definition and Usage
The ADDTIME() function adds a time interval to a time/datetime and then returns the time/datetime. Continue reading MySQL ADDTIME Function