4

This question already has an answer here:

I was trying out some queries in Data Explorer and noticed that, column CreationDate in table Votes doesn't contain the full timestamp. Only the date part is present and time part is set to 00:00:00.

Have a look at this query.

It would be nice to have the full timestamp. Possible uses of this are determining how many votes are cast immediately after posting, how many are cast within an hour, and so on.

I read the other post where Greg makes the point that:

up/down voting patterns could strongly correlate with other activity on the site (questions, answers, comments).

But, all these details about posts, comments are available with exact timestamp in User's profile as well as in Data Explorer. The exact voting timestamp can be seen in the Reputation tab. So, if I want to guess who voted me, I can do so by looking at this data. Having exact voting timestamp in Data Explorer won't provide any extra information to aid guessing.

marked as duplicate by Aza, Lance Roberts, Hugo Dozois, Makoto, Undo Nov 25 '13 at 2:40

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 1
    The exact time is omitted to prevent people from finding out who voted where. Pretty sure it's already explained somewhere... going to search. – Shadow The Curly Braced Wizard Oct 1 '13 at 10:38
  • meta.stackexchange.com/a/148466/161198 @ShaWizDowArd – Bart Oct 1 '13 at 10:44
  • @ShaWizDowArd - Voting (up-down) is anonymous on Data Explorer too. So probably the time is not removed for that purpose. – hims056 Oct 1 '13 at 10:44
  • @Bart found the exact dupe. :) – Shadow The Curly Braced Wizard Oct 1 '13 at 10:45
  • 1
    Not entirely convinced with the reason. One can check the reputation tab on his profile for the exact time he received the votes. – Noel Oct 1 '13 at 10:57
  • @Ramblin'Man OK, I understand - but this requires you to check each user manually. Having the information in the database will make it too easy and harm the privacy of voting. – Shadow The Curly Braced Wizard Oct 1 '13 at 14:59