You're currently viewing posts by Pinsider Richthofen.
Click here to go back to viewing the entire thread.
The 'UNIX Epoch' is Jan 1st, 1970. The way Unix/Linux computers store time is they count the seconds from this date. So if the forum was migrated from a different system, and that system didn't have a value for 'joined date', then the value would be empty/minimum value.
Quoted from Pinchroma:It's not the way it stores time but rather calculates it. Using a GTOD function (get time of day) which seems trivial but is actually the most expensive Calculation wise of ANY system/kernel level call. The entire Linux "real time" kernel is dedicated to GTOD and it's normalization.
My guess is that the database is MySQL or PostgreSQL. Every account has a 'first joined date' value. I bet if you use PHP's date formatting functions (or as cast to PHP's DateTime object from a null value or empty DateTime MySQL colun), and pass NULL from an account that has no first joined date, it will give you the Epoch. Just conjecture, but since I've seen that behavior before I wouldn't be surprised.
You're currently viewing posts by Pinsider Richthofen.
Click here to go back to viewing the entire thread.
Wanna join the discussion? Please sign in to reply to this topic.
Great to see you're enjoying Pinside! Did you know Pinside is able to run without any 3rd-party banners or ads, thanks to the support from our visitors? Please consider a donation to Pinside and get anext to your username to show for it! Or better yet, subscribe to Pinside+!
This page was printed from https://pinside.com/pinball/forum/topic/pinside-member-since-1970?tu=Richthofen and we tried optimising it for printing. Some page elements may have been deliberately hidden.
Scan the QR code on the left to jump to the URL this document was printed from.
