Funny observation

[EricDaRed]

I was scrolling randomly through the forums out of boredom and I came across some closed threads that say they were from 1970...

Strange. Why is that?

EDIT: Here's a link to an example. Scroll down to the last 3 entries, https://www.hiveworkshop.com/forums/forumdisplay.php?f=202&order=desc&page=332.

 

[Ghan_04]

I see two possibilities.

1. Random error.
2. Someone's been playing with the SQL database...

Care to post a link to said threads?

 

[Pyritie]

A bunch of user accounts say their join date was 1st Jan 1970 as well.

I think it was just a bunch of lost data from the wc3s merge, but I'm just guessing.

 

[TheDivineBoss]

I see two possibilities.

1. Random error.
2. Someone's been playing with the SQL database....

Care to post a link to said threads?

Hm who could do that..

Hm...

 

[Earth-Fury]

http://en.wikipedia.org/wiki/Unix_time

Unix time, or POSIX time, is a system for describing points in time: it is the number of seconds elapsed since midnight Coordinated Universal Time (UTC) of January 1, 1970, not counting leap seconds.

A timestamp with a value of 0 is midnight, January 1st, 1970. Random error.

 

[madcat2]

lol.

Now if you come by a thread that is made 6/6/6 Then sorry guys I'm, out and running away 0_o.

 

[~Void~]

The closed Hero Contest thread has 666 posts.

 

[Samuraid]

http://xkcd.com/376/

As EF suggested, some of the topics imported from Wc3Search did not have their timestamps set correctly, so they defaulted to 0, which results in a date of January 1st, 1970 ± the number of hours in your timezone offset from UTC.

 

[EricDaRed]

Mystery solved. Cool.