by using this syntax you can fin it-
select year(GETDATE()) —Year select month(GETDATE()) —Month select day(GETDATE())
Loading
How To Get Year , Month , Date In Numeric ?
4 Answers
Rajeev KumarPosted Apr 6, 2023, 12:15 PM
By the function datetime
Mukesh KumarPosted Aug 29, 2017, 8:33 PM
SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 101) AS [MM/DD/YYYY]
Rajavel GPosted May 12, 2017, 1:49 AM
select year(GETDATE()) --Year
select month(GETDATE()) --Month
select day(GETDATE()) --Day
Satyaprakash SamantarayPosted Feb 7, 2017, 3:52 AM