In this tutorial, we will learn about the MySQL TIME_FORMAT() function. The time value in MySQL is of the format “HH:MM:SS” and in the 24 hour format. However, such a time value may be difficult to read for some people – who prefer the 12 hour format accompanied by AM/PM. Some people may not prefer …
In this tutorial, we will study the MySQL DATE_ADD() and DATE_SUB() functions. DATE_ADD() and DATE_SUB() are a variation of the ADDDATE() and SUBDATE() functions. The main difference is that DATE_ADD() and DATE_SUB() only have one syntax each, not two syntaxes like ADDDATE() and SUBDATE(). The DATE_ADD() function is used to add a date or time …
In this tutorial, we will study the MySQL EXTRACT() function. The EXTRACT() function is a combination of the date functions and others like WEEK() and QUARTER(), and the time functions and others like MICROSECOND(). The EXTRACT() function is used to extract a part from a date or datetime value. This part can be day, month, …
In this tutorial, we will study the MySQL PERIOD_DIFF() function. In the last article, we saw the MySQL PERIOD_ADD() function. Now, you must be wondering, is there a function to subtract periods? Well there is one! Suppose you have a table in which you store the details of the invoices you have to pay- Id, …
In this tutorial, we will study the MySQL PERIOD_ADD() function. Suppose you have a table in which you store the details of the invoices you have to pay- Id, Name of the beneficiary, the amount to be paid, and the period in which the amount should be paid. Now due to Covid-19, all these beneficiaries …
MySQL PERIOD_ADD() Function – Easy Practical Examples Read More »
In this tutorial, we will study the MySQL GREATEST() and LEAST() functions. Suppose you have a ‘Triangles’ table that stores the length of the three sides of each triangle in three separate columns. You have been tasked to find the longest and the shortest side of each triangle. How do you do this? Normally, you …
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 »