C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time Subdate() FunctionThe subdate() is a MySQL date/time function. It is used to get the date which is subtracted by given intervals. SyntaxSelect subdate(date, interval value unit); kOr Select subdate(date, days); ParameterDate : date by which interval is to be subtracted. Days : number of days in which interval is to be subtracted. Value : time or date interval to be subtracted. Unit : type of interval such as DAY, MONTH, MINUTE, HOUR and so on. Following can be one of them.
ReturnsThis unction returns the date which is subtracted by given intervals. Example 1
Next TopicMySQL datetime
|