C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time timestamp() FunctionThe timediff() is a MySQL date/time function. It is used to convert the expression into datetime/time. Syntaxselect timestamp(expression, [interval]) Parameter:Expression : time/datetime value to be converted Interval : it is optional, it is added into time value Returns:This function returns a datetime value. Example 1select timestamp('2018-10-03'); Output: Example 2select timestamp('2018-10-03 01:13:42'); Output:
Next TopicMySQL datetime
|