--GETDATE -- Gives the "current date & time". --DAY() --Just gives the DAY from the current date. select GETDATE(), DAY(GETDATE()) as 'NO.OF.DAYS'; --Done in months ...
DATE_SUB - Subtracts a time/date interval from a date and then returns the date DAY - Returns the day of the month for a given date DAYNAME - Returns the weekday name for a given date DAYOFMONTH - ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback