Friday, November 29, 2019

Select the first day of a month in SQL

Month First Day


SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS StartOfMonth


SELECT
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) AS StartOfYear,
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, -1) AS LastDayOfYear,
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, 0) AS FirstOfNextYear,
   DATEADD(ms, -3, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, 0)) AS LastTimeOfYear

No comments:

Post a Comment

base 64 convert to image

public Image LoadImage() {     //data:image/gif;base64,     //this image is a single pixel (black)     byte[] bytes = Convert.FromBase6...