How to get the date difference, current date, only year, day month in SQL Server
How to get the current date in SQL Server List of commonly used data and time functions:GETDATE()DATEADD()DATEPART()DATEDIFF()DATENAME()DAY()MONTH()YEAR() How to get the current data in SQL Server GETDATE()GETDATE() is very common used method which returns exact date time from the system. It does not used any parameter. Lets see as follows: How to add and subtract datatime in SQL…












