Day,Month,Year of DATE

CGN007
Posted by CGN007 under Sql Server category on | Points: 40 | Views : 1067
 SELECT DAY(GETDATE())   AS [CurrentDay],
DATENAME(MONTH, GETDATE()) AS [CurrentMonth],
YEAR(GETDATE()) AS [CurrentYear]

Comments or Responses

Login to post response