SQL DATENAME()
The DATENAME() function returns a string, navarchar type, that represents a specified date part of date ,it can be a day , month ,year or time of specific date.
2,704 total views
Home » SQL SERVER » SQL Functions »
Date Functions
SQL Date functions are used to manipulate with date strings.
SQL DATEFROMPARTS
SQL DATEFROMPARTS() function is a date function that returns a date value that maps to a year, month, and day values.
2,596 total views, 2 views today
SQL DATEPART()
SQL DATEPART() function is used to get a part of any specific date , it could be a day , month ,year or time of specific date.
2,028 total views, 4 views today
SQL DATEDIFF()
SQL DATEDIFF() function is used to calculate the difference between two dates.
2,542 total views, 4 views today
SQL DATEADD()
SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.
1,086 total views, 4 views today
SQL CURRENT_TIMESTAMP
SQL CURRENT_TIMESTAMP function returns the current date and time .
941 total views, 1 views today
SQL GETDATE()
SQL GETDATE() function returns the current date and time.
1,186 total views, 2 views today
SQL EOMONTH()
SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.
8,316 total views, 3 views today