C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time second() FunctionThe second() is a MySQL date/time function. It is used to get the second portion from the given date/datetime. Syntaxselect second(date_value); Parameter:date_value : date/datetime value for getting second. Returns:This function returns the second portion of a date value. Example 1Select second('2018-09-29 01:21:24.000002'); Output: Example 2select second('02:25:24.000004'); Output:
Next TopicMySQL datetime
|