https://www.sqlines.com/ 2026-04-14T06:36:43+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2012-06-26T14:07:53+00:00 https://www.sqlines.com/sql-server/functions/datediff?rev=1340719673&do=diff SQL Server DATEDIFF function returns the difference in seconds, minutes, hours, days, weeks, months, quarters and years between 2 datetime values. Quick Example: -- The difference is days between today and yesterday SELECT DATEDIFF(dd, GETDATE() - 1, GETDATE()); -- Returns: 1 -- The number of seconds in 24 hours SELECT DATEDIFF(ss, GETDATE() - 1, GETDATE()); -- Returns: 86400 text/html 2012-07-25T15:09:22+00:00 https://www.sqlines.com/sql-server/functions/error?rev=1343228962&do=diff In SQL Server, @@ERROR function returns the error code of the last Transact-SQL statement executed. Note that even IF and PRINT statements reset the error code, so you have to check it immediately after executing a DML or DDL statement, or save it to a local variable and check later. text/html 2011-12-11T09:09:15+00:00 https://www.sqlines.com/sql-server/functions/rtrim?rev=1323594555&do=diff RTRIM function truncates all trailing blanks from a string. Syntax RTRIM(string) Quick Example SELECT RTRIM('A '); CHAR(160) Non-breaking space (Unicode 160, or HTML  ) is not removed by RTRIM Versions: SQL Server 2008 and 2005 Related Functionality in SQL Server Related functions for RTRIM in SQL Server: text/html 2011-12-29T12:51:50+00:00 https://www.sqlines.com/sql-server/functions/year?rev=1325163110&do=diff YEAR function returns the year of the specified datetime value. Syntax YEAR(datetime) Quick Example SELECT YEAR('2010-09-17'); Return Type INT Alternative DATEPART(YEAR, datetime) Note Returns 1900 if datetime contains only time part Version: SQL Server 2008 R2