C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time Subtime() FunctionThe subtime() is a MySQL date/time function. It is used to get the time/datetime which is subtracted by certain intervals. Syntaxselect subtime(start_value, time); Parameter:Start_value: time/datetime by which interval is to be subtracted. Time: time in which interval is to be subtracted. ReturnsThis function returns the time/datetime which is subtracted by certain intervals. Example 1select subdate('2018-10-01 08:01:23.000005','3.000003'); Output: Example 2select subdate('2018-10-01 08:01:23.999995','3.000003'); Output:
Next TopicMySQL datetime
|