weird thread in ps2 forum shows Jan 1st 1970 as last post date

[Thiele]

i went to show threads from beginning in ps2 forum and sorted by last posting date in descending, went to the last page and found this:





last post 1st January 1970

 

[Duke]

Looks like a database error to me.

 

[HACKr]

Dec 31 1969

zOMG! The Beatles are going to break up again!

 

[Jordan]

Yes, it's most likely some random database error. Don't worry about it.

 

[ND4SPD]

Dec 31 1969

zOMG! The Beatles are going to break up again!

Lmao! I'm sorry that made me chuckle pretty good.

 

[ßen]

Now it says Jan 1st 1970. Odd.

 

[GilesGuthrie]

January 1st 1970 is the beginning of the UNIX epoch. Where dates are not being handled correctly, and are returned from the database as zero (most normally where the field name or type holding the date has changed but the code has not been updated) this will be parsed as January 1st 1970.

Storing dates as timestamps uses a large integer representing the number of seconds since 01.01.1970. It's actually a really convenient way of managing dates because you can manipulate them (for time zones) really easily.