In this tutorial, we will study the MySQL SUBTIME() function. Suppose you have a table which contains the names of shops and their opening time. Now suppose it is the summer season and all these shops decide to open an hour early. You have been tasked with subtracting an hour from all the time values. …
MySQL SUBTIME() – Subtract from Time Values in MySQL Read More »
In this tutorial, we will study the MySQL YEARWEEK() function. The MySQL YEARWEEK() function is a variation of the WEEK() function. The main difference is that, in addition to the week number, it also returns the year number. The output is in the format – YYYYWW; where YYYY indicates the year value and WW indicates …
MySQL YEARWEEK() – Find the Year and Week Numbers from Date Read More »
In this tutorial, we will study the MySQL SUBDATE() function. Suppose you are a HR manager and you notice that an intern who you tasked with filling up an Employee table in MySQL filled up wrong joining dates of all employees from the Executive department. He added a year to the original joining dates of …
MySQL SUBDATE() – Subtract from DateTime Values in MySQL Read More »
In this tutorial, we will study the MySQL ADDDATE() function. Suppose you are an HR manager and you have been given a table which contains the details of every employee in the company. Details include their ID, Name, joining date, department, email, salary, and office code. The company has a policy of offering an initial …
MySQL ADDDATE() – Adding Numbers to DateTime Values in MySQL Read More »
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 …