Getting the First day and last day of a month in SQL Server
11.6 هزار بار بازدید -
3 سال پیش
-
In this video, we will
In this video, we will be looking at the first and last days of the current month, and future and past months.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft-sql-server
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpivot-ssas-tabular-dax
----
My Excel for PC courses are:
Beginner to Excel - rebrand.ly/microsoft-excel-specialist
Intermediate to Expert Advanced - rebrand.ly/microsoft-excel-expert
Power Table, Get and Transform and Power Pivot - rebrand.ly/visualizing-data-excel
VBA macros for Excel - rebrand.ly/excel-vba-pc
----
You can find in the first day in SQL Server by using DATEFROMPARTS - but how can you find the first day of the next or previous month?
It's a lot easier to find the last day in SQL Server by using EOMONTH.
3 سال پیش
در تاریخ 1400/04/02 منتشر شده
است.
11,600
بـار بازدید شده