Convert numbers year, month and days and more to dates in SQL Server - with ...FROMPARTS functions скачать в хорошем качестве

Convert numbers year, month and days and more to dates in SQL Server - with ...FROMPARTS functions

In this video, we will be converting numbers to dates using various functions ending with FROMPARTS. 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 ---- In Excel, you can convert numbers to dates using the DATE function. However, because of the various date/time formats, there are six different functions that we can use in SQL Server: DATEFROMPARTS is the equivalent of DATE, using year, month and day. SMALLDATETIMEFROMPARTS also uses hour and minute. DATETIMEFROMPARTS adds seconds and milliseconds. TIMEFROMPARTS uses hour, minutes, seconds, fractions of seconds and precision (how many decimal places). DATETIME2FROMPARTS add years, months and days. and DATETIMEOFFSETFROMPARTS includes the hour offset and minute offset.