In this tutorial, we will study the MySQL STR_TO_DATE() function. Suppose you have a table of details of a few people. One of the columns in the table is DOB which specifies the date of birth of each individual as a string. An example of the date string format is – ‘August 29, 2020’. You …
MySQL STR_TO_DATE() – Convert Date String to MySQL Date Read More »
In this tutorial, we will learn about the MySQL GET_FORMAT() function. Before you proceed with this article, I would highly encourage you to read the DATE_FORMAT() article as this tutorial builds on concepts learnt in that article. Suppose you have a list of joining dates of employees in your company. These dates have been stored …
MySQL GET_FORMAT() – Convert MySQL Dates to Standardized Formats Read More »
In this tutorial, we will study the MySQL COALESCE() function. Suppose you have a table of contact details of a thousand people. The contact details can be a mobile number, a home number or a work phone. There is a column for each of these contact details. Note that not all contact detail columns are …
In this tutorial, we will learn about the MySQL DATE_FORMAT() function. The date value in MySQL is in the format “YYYY-MM-DD”. However, such a date value may be difficult to read for some people – who prefer it in some other format like DD/MM/YYYY or MM/DD/YYYY. Some people may prefer to see the day name …
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 …