C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time microsecond() FunctionThe microsecond() is a MySQL date/time function. It is used to get the value of microsecond from given datetime or time. Syntaxselect microsecond(date_value); Parameter:Date_value: datetime or time value for getting microsecond. Returns:This function returns the microsecond portion of a date value. Example 1Select microsecond('10:18:25.000002'); Output: Example 2Select microsecond('2018-9-28 10:18:25.000002'); Output:
Next TopicMySQL datetime
|