In this tutorial, we will study the MySQL ADDTIME() function. Suppose you have a table which contains the names of shops and their opening time. Now suppose during winters, these shops decide to open an hour late. You have been tasked with adding an hour to all the time values. This situation calls for the …
In this tutorial, we will learn about the MySQL TIME_TO_SEC() function. Suppose you have been given a bunch of time values from a stopwatch in a MySQL table and you have to convert them to their equivalent value in seconds. How would you do that? One way is to convert the time values manually to …
MySQL TIME_TO_SEC() – Converting Time to Seconds Value Read More »
In this tutorial, we will study the MySQL MAKETIME() function. Suppose you have individual values of hour, minute and seconds values and you need to enter these values in a table such that it is a time value. This is where MySQL MAKETIME() is useful. The MAKETIME() function is used to make a time value. …
In this tutorial, we will study the MySQL DATEDIFF() function. Suppose you are an HR executive at a company and you have data on the check-in date and time for each employee for today as well as the date they first joined the company in a table. The CEO of the company has tasked you …
MySQL DATEDIFF() – Find the Difference Between the Dates in MySQL Read More »
In this tutorial, we will learn about the MySQL LAST_DAY() function. Finding the last day of a month has many applications while working with databases. Different months have a different last day. Some months have 30 days, some have 31 days and February has 28 days in a non-leap year while 29 days in a …
MySQL LAST_DAY() – Find the last day of a month in MySQL Read More »
In this article, we will study the various Information Functions in MySQL. As the name suggests, information functions provide us with information about our MySQL database. These functions are very useful in understanding the technicalities of the MySQL database. They provide you with valuable information like the version of your MySQL database, the current user …
In this tutorial, we will study the MySQL TIMEDIFF() function. Suppose you are a manager at a company and you have data on the check-in date and time, and check-out date and time for each employee for a day. You have been tasked to find out their work hours. This would basically mean the difference …
In this tutorial, we will learn about the MySQL SEC_TO_TIME() function. Suppose you are an athletics coach and you are timing the runs of your athletes who are running a race. Your stopwatch only counts in seconds (just consider you are using some ancient stopwatch). Now, you want to store these timing values in the …
MySQL SEC_TO_TIME() – Convert Seconds to a Time Values in MySQL Read More »
In this tutorial, we will study the MySQL MAKEDATE() function. Suppose someone tells you that their date of birth is the 45th day in the year 2000 and you need to enter that in their table. Of course, you could always ask them to be more specific but let’s just take this challenge, shall we? …
MySQL MAKEDATE() – Find Date From Day Number in MySQL Read More »
In this tutorial, we will study the MySQL WEEK() function. Every year has around 52 to 53 weeks. Suppose you want to find out the week number of a particular date. For this purpose, MySQL provides us with the WEEK() function. The WEEK() function is used to return the week number for a specified date. …
MySQL WEEK() – Find the week number from date in MySQL Read More »