How To Get Year , Month , Date In Numeric ?

3

Reply

How To Get Year , Month , Date In Numeric ?

Satyaprakash Samantaray

Satyaprakash Samantaray

8y

1.7k

3

Satyaprakash Samantaray

select year(GETDATE()) --Year select month(GETDATE()) --Month select day(GETDATE()) --Day

Satyaprakash Samantaray

8y

Mukesh Kumar

By the function datetime

8y

SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 101) AS [MM/DD/YYYY]

8y