While reviewing Late Answers, I came across this answer [Get the current month number in SQL Server, 1 for january, 12 for december](https://stackoverflow.com/questions/19465328/get-the-current-month-number-in-sql-server-1-for-january-12-for-december/26568968#26568968), which is 11 lines of SQL code (and quite complex).

The accepted answer is: `SELECT MONTH(GETDATE())`

Lets say this answer is correct (honestly, I haven't tested the code). Is this a useful answer?

I'm very aware that the same problem can have innumerous solutions, but can we consider this a solution?

I've flagged the answer as *not an answer* and it was declined (I'm not complaining!).

(I've noticed the user entered the same exact answer in two questions, so I assume a) The questions are duplicate OR b) this seems like spam / excessive promotion, but for the sake of this argument lets not focus on this).