Langsung ke konten utama

select the first day of a month in SQL Server

select the first day of a month in SQL Server
SELECT DATEADD(month,DATEDIFF(month,0,GETDATE()),0) AS StartOfMonth ,DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),1) as StartOfMonth_1

Komentar