Interviews - C# Corner

Satyaprakash Samantaray
How To Get Year , Month , Date In Numeric ?
By Satyaprakash Samantaray in SQL Server onFeb 07 2017
  • Satyaprakash Samantaray
    Feb, 2017 7

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

    • 5
  • Mukesh Kumar
    Aug, 2017 29

    By the function datetime

    • 0
  • Rajavel G
    May, 2017 12

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

    • 0

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS