C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time time() FunctionThe time() is a MySQL date/time function. It is used to get the time from given time/datetime. Syntaxselect time(expression); Parameter:Expression: time/datetime to be extracted. Returns:This function returns the time from the given time/datetime. Example 1select time('2018-10-01 08:01:23.000005'); Output: Example 2select time('08:01:23'); Output:
Next TopicMySQL datetime
|