Thats awesome. Tx so much.
One last question.
joindate. I see it stored as something like this "1186389780"
What is this date format and how I can I see its as say "mm/dd/yyyy"
I tried firing a sql statement like this:
Select
DATE_FORMAT(joindate, '%M %e, %Y, %l:%i%p') as joindate, email, username, password, birthday, IF(options & 16, 1, 0) as acceptsadminemail from user
But the join date returns as null
What am I doing wrong?
|