Skip to content

Tag Archives: DBMS-SQL

The DIFFERENCE() function compares two different SOUNDEX values, and return the value of the integer. This value measures the degree that the SOUNDEX values match,… Read More
1. Sin() Function : In MariaDB, SIN() function is used to returns the sine of a number. In this function, a number will be passed… Read More
LPAD() function in MySQL is used to pad or add a string to the left side of the original string.  Syntax :   LPAD(str, len, padstr)… Read More
UTC_TIMESTAMP() function in MySQL is used to check current Coordinated Universal Time (UTC) date and time value. It returns the current UTC date and time… Read More
Prerequisite – Create database in MS SQL Server To Create a Full Database Backup, the below methods could be used – SQL Server Management Studio.… Read More
The SQL Server IIF() function has three parameters. IIF() function judges or evaluates the first parameter and returns the second parameters if the first parameters… Read More
1. FLOOR() Function : The MariaDB, The FLOOR function is used for returns the largest integer value that is equal to or less than a… Read More
UTC_TIME() function in MySQL is used to check current Coordinated Universal Time (UTC) time value. It returns the UTC time value in ‘HH:MM:SS’ or HHMMSS… Read More
1. MID() Function : In MariaDB, the MID() Function is used to extract a substring from a string. It will return a substring of a given… Read More
1. LPAD Function : In MariaDB, the LPAD Function is used for the string that is left-padded with a specified string to a given length.… Read More
PI() function in MySQL is used to return the Pi value. The default number of decimal places displayed is seven, but MySQL uses the full… Read More
CRC32() function in MySQL is used to compute cyclic redundancy value. It returns NULL if the argument is NULL otherwise, it returns a 32-bit unsigned… Read More
WEEKOFYEAR() function in MySQL is used to find the week number for a given date. If the date is NULL, the WEEKOFYEAR function will return… Read More
CURRENT_TIME() function in MySQL is used to check the current time. It returns the current time as a value in ‘hh:mm:ss’ or hhmmss format, depending… Read More
UTC_DATE() function in MySQL is used to check current Coordinated Universal Time (UTC) date. It returns the UTC date value in ‘YYYY-MM-DD’ or YYYYMMDD format,… Read More

Start Your Coding Journey Now!