DAY (Transact-SQL) - SQL Server | Microsoft Docs
https://docs.microsoft.com/en-us/sql/t-sql/functions/day-transact-sql
Nov 30, 2021 · If date contains only a time part, DAY will return 1 - the base day. Examples. This statement returns 30 - the number of the day itself. SELECT DAY('2015-04-30 01:01:01.1234567'); This statement returns 1900, 1, 1. The date argument has a number value of 0. SQL Server interprets 0 as January 1, 1900. SELECT YEAR(0), MONTH(0), DAY(0); See also
DA: 68 PA: 88 MOZ Rank: 88