Browsing Category
SQL
SQL is a standard language for storing, manipulating and retrieving data in databases.
Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.
SQL Log10 Function: Complete Guide
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)…
SQL CURRENT_TIME(): Complete Guide
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: Complete Guide
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…
SQL STR() Function: Complete Overview
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: Complete Guide
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() Function: Complete Guide
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: Complete Guide
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…
SQL ROUND() Function: The Complete Guide
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: Complete Guide
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: The Complete Guide
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…
SQL CONVERT Function: Complete Guide
SQL CONVERT() function converts the value (of any type) into a specified datatype.
SQL CONVERT
SQL CONVERT() is a built-in function that is used for converting an expression from one data type to another data type. Here, if the…