Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

complete date is 1 year or not sql server

SELECT
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) AS StartOfYear,
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, -1) AS EndOfYear
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #complete #date #year #sql #server
ADD COMMENT
Topic
Name
5+8 =