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. What’s the best way to search for a UPC code in a Database?
  50. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  51. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  52. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  53. What is the difference between UNION and UNION ALL?
  54. Case in Select Statement
  55. ORA-00904: invalid identifier
  56. SQL WITH clause example [duplicate]
  57. Inserting multiple rows in a single SQL query? [duplicate]
  58. Unknown column in ‘field list’ error on MySQL Update query
  59. Unknown column in ‘field list’ error on MySQL Update query
  60. SQL Inner-join with 3 tables?
  61. The wait operation timed out. ASP
  62. What is SELF JOIN and when would you use it? [duplicate]
  63. The wait operation timed out. ASP
  64. Conversion failed when converting date and/or time from character string while inserting datetime
  65. how to fix oracle ORA-01722 invalid number error
  66. MySQL – Operand should contain 1 column(s)
  67. SQL SELECT WHERE field contains words
  68. Conversion failed when converting date and/or time from character string while inserting datetime
  69. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  70. Insert Data Into Temp Table with Query
  71. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  72. MySQL create table if not exists and insert record only if table was created
  73. error, string or binary data would be truncated when trying to insert
  74. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  75. NOT IN vs NOT EXISTS
  76. SQL SELECT WHERE field contains words
  77. Online SQL Query Syntax Checker
  78. Must declare the scalar variable
  79. ORA-00979 not a group by expression
  80. T-SQL split string
  81. ORA-00907: missing right parenthesis
  82. How do I use properly CASE..WHEN in MySQL
  83. Must declare the scalar variable
  84. Rename column SQL Server 2008
  85. Why do we need “Relationships” between tables at all?
  86. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  87. Using group by on multiple columns
  88. Efficiently convert rows to columns in sql server
  89. How can I do a FULL OUTER JOIN in MySQL?
  90. Nested select statement in SQL Server
  91. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  92. Using group by on multiple columns
  93. SQL SELECT WHERE field contains words
  94. SQL Query with NOT LIKE IN
  95. MySQL query String contains
  96. What’s the difference between VARCHAR and CHAR?
  97. Case statement in MySQL
  98. How to declare a variable in MySQL?
  99. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  100. Finding duplicate values in a SQL table

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)