Thursday, February 24, 2005
Separating day.month and year
This is a simple query that separates day,month and year.
SELECT DATEPART(day,GETDATE()) AS Day ,DATEPART(month, GETDATE()) AS Month, DATEPART(year,GETDATE()) AS Year
SELECT DATEPART(day,GETDATE()) AS Day ,DATEPART(month, GETDATE()) AS Month, DATEPART(year,GETDATE()) AS Year
// posted by azamsharp @ 9:10 PM 
