Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...

Imagine you have a date and time stored in your database, like "2023-10-26 15:30:00". SQL functions are like tools to take apart this date and time or rebuild it in a different format.

SQL provides many built-in functions to manipulate date and time data, such as extracting, adding, subtracting, formatting, or converting. For example, you can use the EXTRACT function to get a ...

Here, I'll discuss conversion functions and the first date and time function. An online companion article will detail the other date and time functions and discuss logical and string functions. 1.

The following tables list the [!INCLUDEtsql] date and time functions. See Deterministic and Nondeterministic Functions for more information about determinism. [!INCLUDEtsql] derives all system date ...

Logical Functions The next grouping of new T-SQL commands is logical functions; they include two new commands, CHOOSE and IIF. These commands are used for logical operations to help control the ...