In this article, we will learn about how to get random records from the database table in MySQL. In MySQL, there is no built-in function to retrieve the random records. In order to achieve this, you can use the ORDER BY RAND() clause in your SQL query.
Read More..In this article, you will learn how to add or subtract years, months, weeks, days, hours, minutes, seconds, microseconds to a DateTime in MySQL. DateTime manipulation is the most common scenario is when we fetching data from the database or storing data in a database. Here, we used the MySQL built-in DateTime functions: ADDDATE(), DATE_ADD(), DATE_SUB(), and add and subtract dates without using any built-in function.
Read More..In this article, you will learn how to calculate the number of months between two specific dates in MySQL. To get a number of months between two specific dates, we use the TIMESTAMPDIFF function and PERIOD_DIFF function of MySQL.
Read More..In this article, we will learn how to get the month name from a date in MySQL. In MySQL, MONTHNAME() function returns the full name of the month for a specified date.
Read More..In this article, we will learn how to get the total number of days in a month in MySQL. There are many ways to get the total number of days in a month by using the current date or by using a specific date. Here are some examples using a current date or using a specific date to get the total number of days in a month.
Read More..In this article, we will learn how to get the name of the day of the week from a date in MySQL. In MySQL, DAYNAME() function returns the full name of the day of the week for a specified date. DAYNAME() function returns a value from Sunday to Saturday as an output.
Read More..In this article, we will learn how to convert UTC to the local timezone in MySQL. When we are working with the big database, it is important to manage the default database time zone. MySQL does not store time zone information when storing timestamps. It also uses the host server time as the basis for generating the output of NOW() function.
Read More..In this article, we will learn about how to deal with date and time in MySQL. In MySQL, it supports a bunch of date and time utility functions that we can use to handle DATE and TIME efficiently.
Read More..In this article, we will learn How to get the First Day and the Last Day of the Month in MySQL.
Read More..