date functions – Page 22

TO_SECONDS() Examples – MySQL

September 5, 2021July 4, 2018 by Ian

In MySQL, the TO_SECONDS() function returns the number of seconds since the year 0.

This function is not to be confused with the TIME_TO_SECONDS() function, which returns the number of seconds in a given time value provided as an argument.

TIME_TO_SEC() Examples – MySQL

September 5, 2021July 4, 2018 by Ian

When using MySQL, you can use the TIME_TO_SEC() function to return the number of seconds in a time value. Specifically, this function returns the time argument, converted to seconds.

This function is not to be confused with the TO_SECONDS() function, which, given a date or datetime argument, returns the number of seconds since year 0.

Here’s how TIME_TO_SEC() works.

TIME_FORMAT() Examples – MySQL

January 28, 2021July 3, 2018 by Ian

In MySQL, you can use the TIME_FORMAT() function to format a time value.

This function works just like the DATE_FORMAT() function, except that the value can only be formatted in hours, minutes, seconds, and microseconds.

See the table at the bottom of this article for a list of format specifiers that can be used with this function.

TIMESTAMPDIFF() Examples – MySQL

January 28, 2021July 3, 2018 by Ian

The MySQL TIMESTAMPDIFF() function is used to find the difference between two date or datetime expressions. You need to pass in the two date/datetime values, as well as the unit to use in determining the difference (e.g., day, month, etc). The TIMESTAMPDIFF() function will then return the difference in the specified unit.

TIMESTAMPADD() Examples – MySQL

January 28, 2021July 2, 2018 by Ian

In MySQL, the TIMESTAMPADD() function allows you to add a specified amount of time to a date or datetime value. You specify the unit to add, as well as how many of that unit to add. It accepts three arguments, which are used for the initial value, the amount to add, and the unit to use.

TIMESTAMP() Examples – MySQL

January 28, 2021July 2, 2018 by Ian

In MySQL, the TIMESTAMP() function returns a datetime value based on the argument/s passed in. You can provide one argument or two. If you provide two, it adds the second one to the first and returns the result.

TIMEDIFF() vs SUBTIME() in MySQL: What’s the Difference?

January 28, 2021July 1, 2018 by Ian

You might have noticed that MySQL has a TIMEDIFF() function and a SUBTIME() function. And you may have noticed that in many cases, they both return the same result. So you may be wondering what the difference is between these two functions?

Let’s find out.

TIMEDIFF() Examples – MySQL

January 28, 2021July 1, 2018 by Ian

The MySQL TIMEDIFF() function returns the difference between two time or datetime values.

The way it works is, you provide the two values to compare, and TIMEDIFF() subtracts the second value from the first, then returns the result as a time value.

TIME() Examples – MySQL

January 28, 2021July 1, 2018 by Ian

When working with MySQL, you can use the TIME() function to extract the time part from a time or datetime value.

The way it works is, you pass the time/datetime expression in as an argument, and TIME() will return the time part.

SUBTIME() Examples – MySQL

January 28, 2021July 1, 2018 by Ian

In MySQL, you can use the SUBTIME() function to subtract a time value from a time or datetime expression.

The way it works is, you provide two arguments; the first is a time or datetime value, and the second is a time value. The SUBTIME() function then subtracts the second argument from the first one and returns the result.