Replace string in SQL Server
Let us suppose we need to update or replace any string value in any table, we could use the below methods – Replace String in… Read More »
Tag Archives: DBMS-SQL
MAKETIME() Function in MySQL
MAKETIME() function : This function in MySQL is used to create and return a time value based on specified hour, minute, and second value. In… Read More »
LEN() Function in SQL Server
LEN() function calculates the number of characters of an input string, excluding the trailing spaces. Syntax : LEN(input_string) Parameter – This method accepts a single-parameter… Read More »
Performing DataBase Operations in XAMPP
XAMPP is a cross-platform web server used to develop and test programs on a local server. It is developed and managed by Apache Friends and… Read More »
CURTIME() function in MySQL
CURTIME() 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 »
HOUR() Function in MySQL
HOUR() function : This function in MySQL is used to return the hour part for a specified date. The range of hours value is from… Read More »
FORMAT() Function in SQL Server
The FORMAT() function is one of the String Function, which is used to format the specified value in the given format. Syntax : FORMAT(value, format,… Read More »
DAYOFYEAR() Function in MySQL
DAYOFYEAR() function: This function in MySQL is used to return the day of the year for a specified date (a number from 1 to 366).… Read More »
EXTRACT() Function in MySQL
EXTRACT() function : This function in MySQL is used to extract a part from a specified date. Syntax : EXTRACT(part FROM date) Parameter : This… Read More »
DATE() and DATE_ADD() Function in MariaDB
1. DATE() Function : In MariaDB, the DATE() function is used to return extracts the date value from a date or datetime expression. In this… Read More »
EXTRACT() and DAYOFYEAR() Function in MariaDB
1. EXTRACT() Function : In MariaDB, the EXTRACT() function is used to return extracts the extracts parts from a date. In this function, the first… Read More »
SUBDATE() function in MySQL
SUBDATE() function in MySQL is used to subtracts a time value (as interval) from a given date. Syntax : SUBDATE(date, INTERVAL expr unit) Parameter :… Read More »
CONVERT_TZ() function in MySQL
CONVERT_TZ() function in MySQL is used to convert the given DateTime from One time zone to another time zone. If the arguments are invalid, the… Read More »
SYSDATE() function in MySQL
SYSDATE() function in MySQL is used to return the current date and time in YYYY-MM-DD HH:MM:SS or YYYYMMDDHHMMSS.uuuuuu format depending on the context of the… Read More »
TIME() function in MYSQL
TIME() function in MySQL is used to extracts the time part from a given time/datetime expression. If the expression is not a time or a… Read More »
