« first day (1555 days earlier)
← previous day
next day →
last day (2439 days later) »
ccorn
11:44
Hi there! It seems that there are (Mod)
Votes.CreationDate earlier than the referenced Posts.CreationDate
. Am I misinterpreting a relation there?
Martin Sleziak
12:02
@ccorn It seems that votes are put into database with midnight as creationdate:
data.stackexchange.com/math/query/862670/votes-older-than-posts
data.stackexchange.com/math/query/862672/…
Meta.SE:
Why is vote time missing in the SE data dump and SEDE?
Other posts
linked there
might be of interest, too.
Like this one:
Vote timestamps have 00:00:00 time
ccorn
Aaaaaah, that explains it (I got negative time-to-vote up to -24h). Many thanks. (Grrr. So I cannot get a distribution of exposure time to votes. Damn.)
As an aside, it seems there is no way to delete useless queries again?
« first day (1555 days earlier)
← previous day
next day →
last day (2439 days later) »
all rooms
Transcript for
Jun
12
Jun '18
14
Jun
19
SEDE - Stack Exchange Data Explorer
Discussion related to the usage of Stack Exchange's Data Explorer
ping-@rolfl-4-help
join this room
about this room
00:00
06:00
12:00
18:00
all times are UTC
site design / logo © 2025 Stack Exchange Inc;
legal
mobile