C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL ADDTIME() FunctionThe addtime() is a MySQL date/time function. It is used to get time/datetime value in which some time intervals are added. Syntaxselect addtime(start_value, time) Parameterstart_value: value for time or datetime in which time is added. time: value for time is as per user requirement. ReturnsThis function returns the time/datetime value in which some time intervals are added. Example 1select addtime('2018-09-22', '11.0000023'); Output: Example 2select addtime('2018-09-22', '11:02.0000023'); Output: Example 3select addtime('2018-09-22', '11:02:45.0000023'); Output:
Next TopicMySQL date/time
|