We want to run a report to see the latest post date for each moderator, to track down moderators who are AWOL. I wrote this query -
Select u.user_display_name, ud.user_last_post_time, ud.user_last_visit_time
from ubbt7_users u, ubbt7_user_data ud
where u.user_id = ud.user_id and
u.user_id in (select m.user_id from ubbt7_moderators m)
but the post time and visit times are just integer strings which will be a royal pain to deal with
Is there any easy way to format these in SQL to show something of value? I'm curious why these weren't stored in the database as date values? Does this mean we can't do any SQL report to give us the info we need? Will I have to create some sort of a PHP page report?
