How To Get Year , Month , Date In Numeric ?

Post

Feb, 2017 7
select year(GETDATE()) --Year select month(GETDATE()) --Month select day(GETDATE()) --Day
- 5
Apr, 2023 6
by using this syntax you can fin it-
select year(GETDATE()) —Year select month(GETDATE()) —Month select day(GETDATE())
- 0
Aug, 2017 29
By the function datetime
- 0
May, 2017 12
SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 101) AS [MM/DD/YYYY]
- 0

Most Popular Job Functions