Get current year in TSQL

Yes, it’s remarkably easy in fact:

WHERE YEAR(A.[reimbursementDate]) = YEAR(GETDATE())

Related Posts:

  1. SQL query to select dates between two dates
  2. DateTime2 vs DateTime in SQL Server
  3. Selecting COUNT(*) with DISTINCT
  4. What is a stored procedure?
  5. Self Join to get employee manager name
  6. How do I UPDATE from a SELECT in SQL Server?
  7. When should I use CROSS APPLY over INNER JOIN?
  8. How can I do an UPDATE statement with JOIN in SQL Server?
  9. How do I escape a single quote in SQL Server?
  10. T-SQL split string based on delimiter
  11. How do I escape a single quote in SQL Server?
  12. IDENTITY_INSERT is set to OFF – How to turn it ON?
  13. Column name or number of supplied values does not match table definition
  14. SQL Server FOR EACH Loop
  15. Get day of week in SQL Server 2005/2008
  16. How to parse XML data in SQL server table
  17. What is the equivalent of ‘describe table’ in SQL Server?
  18. How do I query for all dates greater than a certain date in SQL Server?
  19. How to insert date values into table
  20. Error converting data type varchar to float
  21. I want to use CASE statement to update some records in sql server 2005
  22. Sql query to insert datetime in SQL Server
  23. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  24. SELECT DISTINCT on one column
  25. Exclude a column using SELECT * [except columnA] FROM tableA?
  26. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  27. TSQL PIVOT MULTIPLE COLUMNS
  28. Convert timestamp to date in Oracle SQL
  29. Query to convert from datetime to date mysql
  30. SQL “select where not in subquery” returns no results
  31. Equivalent of Oracle’s RowID in SQL Server
  32. Subtract one day from datetime
  33. Can I use multiple “with”?
  34. Is it possible to specify condition in Count()?
  35. SQL Server dynamic PIVOT query?
  36. How do I query for all dates greater than a certain date in SQL Server?
  37. Error converting data type varchar
  38. Temporary table in SQL server causing ‘ There is already an object named’ error
  39. I want to use CASE statement to update some records in sql server 2005
  40. How to calculate age (in years) based on Date of Birth and getDate()
  41. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  42. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  43. How can I group by date time column without taking time into consideration
  44. Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
  45. “select * into table” Will it work for inserting data into existing table
  46. SUM OVER PARTITION BY
  47. Update query using Subquery in Sql Server
  48. Varchar invalid for Sum operator
  49. Unknown column in ‘field list’ error on MySQL Update query
  50. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  51. SQL SELECT WHERE field contains words
  52. T-SQL split string
  53. Using group by on multiple columns
  54. Efficiently convert rows to columns in sql server
  55. Nested select statement in SQL Server
  56. What’s the difference between VARCHAR and CHAR?
  57. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  58. How to split the name string in mysql?
  59. Sql Server equivalent of a COUNTIF aggregate function
  60. Simple PHP Pagination script
  61. ORA-12560: TNS:protocol adaptor error
  62. SQL – HAVING vs. WHERE
  63. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  64. Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
  65. How to SUM two fields within an SQL query
  66. Difference between numeric, float and decimal in SQL Server
  67. SQL Server: Invalid Column Name
  68. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  69. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  70. Cast from VARCHAR to INT – MySQL
  71. Must declare the scalar variable
  72. postgresql: error duplicate key value violates unique constraint
  73. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  74. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  75. Insert into a MySQL table or update if exists
  76. How to round down to nearest integer in MySQL?
  77. How do I reset a sequence in Oracle?
  78. MySQL error: key specification without a key length
  79. Update statement with inner join on Oracle
  80. SQL: IF clause within WHERE clause
  81. How to write a foreach in SQL Server?
  82. What does Include() do in LINQ?
  83. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  84. Get everything after and before certain character in SQL Server
  85. LEFT function in Oracle
  86. How do I view the Explain Plan in Oracle Sql developer?
  87. ORA-01779: cannot modify a column which maps to a non key-preserved table
  88. SQLite string contains other string query
  89. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  90. WordPress SQL LIKE request doesn’t work for fields with special symbols
  91. posts_where Fails with More than One Custom Field in Query
  92. Restose content from revisions – sql query
  93. Better way to migrate to server?
  94. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  95. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  96. Help me SELECT thumbnail from SQL and use
  97. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  98. Creating a “forum” – showing last post or last commented post
  99. Replace Unwanted Space in Post Content URL
  100. How to write inner join using posts_clauses?

Leave a Comment