The FORMAT function in SQL Server - extracting single or multiple parts of a datetime

In this video, we will be extracting parts of dates and times using the FORMAT function. My SQL Server Udemy courses are: 70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft-sql-server 98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals 70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpivot-ssas-tabular-dax ---- My Excel for PC courses are: Beginner to Excel - https://rebrand.ly/microsoft-excel-specialist Intermediate to Expert Advanced - https://rebrand.ly/microsoft-excel-expert Power Table, Get and Transform and Power Pivot - https://rebrand.ly/visualizing-data-excel VBA macros for Excel - https://rebrand.ly/excel-vba-pc ---- The FORMAT function in SQL Server is fairly similar to the FORMAT function in Excel. However, there are a few differences. Firstly, you can use .NET standard coding strings - see https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings for more details. Secondly, you can use custom date and time coding strings, which are more extensive than in Excel - see https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings Thirdly, in Excel you can use 'mm' for months, and 'hh' for hours between 0 and 23. However, in SQL Server you need to use 'MM' for months, and 'hh' for hours between 0 and 11, and 'HH' for hours between 0 and 23.