How to get FIRST DAY of MONTH in SQL

preview_player
Показать описание
This video is about how to get FIRST DAY of MONTH in SQL.

Script:
SELECT DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),1)

Keywords:
How to get FIRST DAY of MONTH in SQL,sql first day of month datepart,t-sql first day of month,ms sql get first day of month,t sql get first day of month,sql get first day of month from getdate,sql get first day of month from date,sql get first date of month,sql get first date of month with year and month,sql server,sql,learn sql,sql first day of month,first date of month,first date of month in sql,first date of month sql,first date sql,first day sql
Рекомендации по теме