Databases

I have learned a lot using online discussion forums. Here is the one that I use explicitly


1) http://www.windowsitpro.com/sqlserver/forums/index.cfm

This is SQL SERVER Magazine forum.

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