SQL

SQL log10 () function is used for returning the natural logarithm of a number to its base 10. SQL log10 The LOG10() is a built-in SQL function that returns the natural logarithm of a number to base 10. Syntax SELECT LOG10 (Number)…

The CURRENT_TIME is a standard-SQL function supported by almost all database systems such as DB2, Firebird, MySQL, PostgreSQL, and SQLite. SQL Server does not support the CURRENT_TIME function; however, you can use the GET_DATE() function…

SQL ABS() function returns the absolute value of a number when passed as an argument, i.e., the negative number gets converted to an absolute positive number. SQL ABS() SQL ABS() is a built-in method is used to get the absolute value of…

The STR() function returns the number as a string. If there is not enough length or decimal to display the resulting string based on the parameters provided, the function will round off the result. SQL STR() SQL STR() is a built-in…

SQL SESSION_USER() function returns the user name of the current context in the current database. The SESSION_USER() function returns the current username and hostname for the MySQL connection. The SESSION_USER() function is equal to the …

SQL SYSUTCDATETIME() returns the datetime2 value that contains a date and time of a computer on which an instance of SQL Server is running. SQL SYSUTCDATETIME() SQL SYSUTCDATETIME() is a built-in Date function used to return the Current…

SQL USER_NAME() function returns the database user name based on the specified id. If no id is specified, this function will return the name of the current user. SQL USER_NAME SQL USER_NAME() is a built-in function that is used for…

The ROUND() is one of the most used SQL functions that return the round number to 2 decimal places. SQL ROUND() SQL ROUND() is a built-in function used for rounding a number to a specific decimal place. Here, the user provides the…

SQL CURRENT_USER function returns the name of the current user in the SQL Server database. SQL CURRENT_USER() SQL CURRENT_USER() is a built-in function that returns the name of a current user in the SQL Server database. MySQL…

SQL PI function is used for returning the mathematical value of the constant π (pie). The PI() function returns the value of PI. SQL PI PI is a mathematical constant number to represent the ratio of a circle’s circumference to its…