General Get Day, Month & Year Parts Separately from Date in Microsoft SQL Server Sometime we need to get Day, Month or Year part only from the given date. We can get it using the DATEPART function. It has following syntax: Where datepart is …