This question has spontaneously devolved into an edit war. The author feels slighted. Here is his "closing volley" and then my ruling as a moderator (hey, I'm just cleaning up stuff).
Final notes:
It is my right, as the person who asked the question, to determine if the the question has been answered in a satisfactory way. At this time I do not feel that there is an answer which fully answers the question I am trying to ask.
There is a lot of other information, which can be seen in the history link on the Q, but I'm here to settle the dispute over content, not the technical accuracy of the answer. So, if you're ALL with me and understand that that is the POINT of this post, then we shall begin.
It is indeed the author's right to determine accuracy. However, as the author, you don't get to retroactively say "oh, you absolutely didn't read my mind and answer what I needed." To wit: Trisped should have considered this portion:
Update:
A correct answer should contain the following information:
- How to add minutes to to a time data type.
- That the proposed solution does not result in a loss of precision.
- Issues or concerns to be aware of in the event that the minutes would be to too large to fit in a time variable, or risk of rolling the time variable over. If there are no issues then please state so.
When he asked the question. Now, that being said, that's a little insensitive of me to say, because sometimes we have to ask the question and have some discussion over what makes it a great question. I don't see any such back and forth, but we can chalk it up to "I re-read the question and this seems to be missing". That's fair. Given the new requirements (which I have a technical answer on, but which this forum is not for technical accuracy but for the running of the site, it being meta, let's keep it to the asking of questions and giving of answers) the answer still seemed valid. So what's up with the rant?
The rant says "Oh, Aaron changed two of my "record" to "row", woe is me". Yes Trisped, I am using sarcasm to make light of the rant. The issue is that apps use records, database tables store records as rows. When discussing query, the technical term is row. You don't get to change that. What you display on screen is a record. Learn the differences in terminology, because your entire programming career will be filled with this sort of nuance. He also removed a comment which was superfluous and didn't add to the conversation, as I've never had rowcount interrupt my query results before. To be honest, I forget how much value it even is anymore. But the point being, when someone with Aaron's expertise removes a comment from a query that he sees as superfluous to the discussion of answering your question, that's not something to get pissy on.
So Trisped, consider your hand smacked at this point, for the following:
- Starting an edit war with a moderator (Jack Douglas) who reverted your edit and asked you to not do that,
- Arguing with people who are trying to tell you what the proper operation of the requested function are,
- Being highly pedantic about the edits of your question without working to engage better clarification of the question.
And with all that said, I feel like if you stay with the network (this sort of thing is the reason people leave the network, but that's a shame) then I think you'll make a great going-forward user of our network. You obviously want to know this stuff, and that's highly important. Don't give up on us yet, just learn that others can edit your stuff and that that's ok! That's all you have to do to earn my blessing, and this whole thing just goes away.
Aaron Bertrand:
You get your hand publicly slapped for deleting your great answer, and for arguing when this should've become a moderation issue, and for your pissy comments (like I haven't left literally dozens of those, so I know I'm absolutely not pure in this case, but I still get my hand smacked, and often).
Thank you for not continuing an edit war, and for being mostly calm.
To everyone else:
Thank you for not getting into an edit war, and for not destroying the basic thread of what's going on here.
What happens now:
If there are actual merits of answering this question to be discussed that aren't technical solutions, then now is the time for Trisped to respond with an answer. He can even rant and rave here, if he likes, because that's what this post is about. However, that will NOT bleed over to the main DBA.SE, this has become a site-operation issue, and not a post editing issue.
23:59:59
+00:00:02
=> ???