У нас вы можете посмотреть бесплатно The FORMAT function in SQL Server - extracting single or multiple parts of a datetime или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
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... 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-powerpiv... ---- My Excel for PC courses are: Beginner to Excel - https://rebrand.ly/microsoft-excel-sp... Intermediate to Expert Advanced - https://rebrand.ly/microsoft-excel-ex... Power Table, Get and Transform and Power Pivot - https://rebrand.ly/visualizing-data-e... 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/dotn... 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/dotn... 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.