Skip to content

Tag Archives: mysql

LOCALTIMESTAMP() function : This function in MySQL is used to return the current date and time in the format of “YYYY-MM-DD HH-MM-SS” (string) or as… Read More
DAYOFMONTH() function : This function in MySQL is used to return the day of the month for a specified date (a number from 1 to… Read More
CURDATE() function : This function in MySQL is used to return the current date. The date is returned to the format of “YYYY-MM-DD” (string) or… Read More
DATEDIFF() function in MySQL is used to return the number of days between two specified date values.  Syntax: DATEDIFF(date1, date2) Parameter: This function accepts two… Read More
DATE_ADD() function in MySQL is used to add a specified time or date interval to a specified date and then return the date. Syntax: DATE_ADD(date,… Read More
DAYNAME() function : This function in MySQL is used to return the weekday name for a specified date. Syntax : DAYNAME(date) Parameter : This method… Read More
ADDDATE() function in MySQL is used to add the specified intervals to the given date and time. It returns the date or DateTime after adding… Read More
ADDTIME() function in MySQL is used to add the specified time intervals to the given date and time. It returns the date or DateTime after… Read More
INSERT ON DUPLICATE KEY UPDATE statement is available in MySQL as an extension to the INSERT statement. Whenever a new row is inserted into a… Read More
As we know that we can use MySQL to use Structure Query Language to store the data in the form of RDBMS. SQL is the… Read More
MONTH() function in MySQL is used to find a month from the given date. It returns 0 when the month part for the date is… Read More
QUARTER() function in MySQL is used to return the quarter of the year for a given date value. It returns a number from 1 to… Read More
PERIOD_DIFF() function : This function in MySQL is used to return the difference between two specified periods. Here the returned results will be in months… Read More
PERIOD_ADD() function in MySQL helps to add a specific number of months to a given period. The PERIOD_ADD() function will return the resultant value in… Read More
EXP() function in MySQL is used to returns E raised to the power of a specified number. Here E(2.718281…) is the base of the natural… Read More

Start Your Coding Journey Now!