How To Get Year , Month , Date In Numeric ?

4

Reply

How To Get Year , Month , Date In Numeric ?

Satyaprakash Samantaray

Satyaprakash Samantaray

8y

4.1k

4

Satyaprakash Samantaray

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

Satyaprakash Samantaray

8y

Rajeev Kumar

by using this syntax you can fin it-
select year(GETDATE()) —Year select month(GETDATE()) —Month select day(GETDATE())

2y

Mukesh Kumar

By the function datetime

8y

Rajavel G

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

8y