The easiest thing would be to use this website:
http://www.unixtimestamp.com/index.php
Fill in your time and copy the UNIX Timestamp (which looks like: 1396294775)
Once done, execute this query.
SELECT
uid
FROM
mybb_users
WHERE
regdate
> '*Timestamp*';
Is that what you mean?