select user_id, username, from_unixtime(user_regdate) from phpbb3_users where user_lastvisit = 0 order by user_regdate;
Categories
Tag: time
Time and Time Again: Managing Time in Relational Databases, Part 19 – RI and Temporal RI:
In terms of the roadmap presented in Part 13, this means that we are putting Step 2 aside, for the moment, and moving on to Step 3, the semantics and implementation of Version Pattern 6. The first part of those semantics which we wish to discuss is what we will call “temporal referential integrity” (temporal RI).