Example
Return the name of the current user in the SQL Server database:
SELECT CURRENT_USER;
Definition and Usage
The CURRENT_USER function returns the name of the current user in the SQL Server database.
Syntax
CURRENT_USER
Author: Mostafa
SQL CONVERT Function
Example
Convert an expression to int:
SELECT CONVERT(int, 25.65);
Definition and Usage
The CONVERT() function converts a value (of any type) into a specified datatype.
Tip: Also look at the CAST() function.
Syntax
CONVERT(data_type(length), expression, style)
SQL COALESCE Function
Example
Return the first non-null value in a list:
SELECT COALESCE(NULL, NULL, NULL, 'iampsp.com', NULL, 'Example.com');
Definition and Usage
The COALESCE() function returns the first non-null value in a list.
Syntax
COALESCE(val1, val2, ...., val_n)
SQL CAST Function
Example
Convert a value to an int datatype:
SELECT CAST(25.65 AS int);
Definition and Usage
The CAST() function converts a value (of any type) into a specified datatype.
Tip: Also look at the CONVERT() function.
Syntax
CAST(expression AS datatype(length))
SQL YEAR Function
Example
Return the year part of a date:
SELECT YEAR('2017/08/25') AS Year;
Definition and Usage
The YEAR() function returns the year part for a specified date.
Syntax
YEAR(date)
SQL SYSDATETIME Function
Example
Return the date and time of the SQL Server:
SELECT SYSDATETIME() AS SysDateTime;
Definition and Usage
The SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.
Syntax
SYSDATETIME()
SQL MONTH Function
Example
Return the month part of a date:
SELECT MONTH('2017/08/25') AS Month;
Definition and Usage
The MONTH() function returns the month part for a specified date (a number from 1 to 12).
Syntax
MONTH(date)
SQL ISDATE Function
Example
Check if the expression is a valid date:
SELECT ISDATE('2017-08-25');
Definition and Usage
The ISDATE() function checks an expression and returns 1 if it is a valid date, otherwise 0.
Syntax
ISDATE(expression)
SQL GETUTCDATE Function
Example
Return the current UTC date and time:
SELECT GETUTCDATE();
Definition and Usage
The GETUTCDATE() function returns the current database system UTC date and time, in a ‘YYYY-MM-DD hh:mm:ss.mmm’ format.
Syntax
GETUTCDATE()
SQL GETDATE Function
Example
Return the current database system date and time:
SELECT GETDATE();
Definition and Usage
The GETDATE() function returns the current database system date and time, in a ‘YYYY-MM-DD hh:mm:ss.mmm’ format.
Tip: Also look at the CURRENT_TIMESTAMP function.
Syntax
GETDATE()