XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / some user_regdate question
Register
1
smdcom
some user_regdate question

hi guys.. need ur explaination...

how to change MySQL date format to normal format... example in user_regdate field will display something like this...

1097005721 << how to change it to date format?

i want to make some query to count user registration current day & yesterday reg...
2
ackbarr
Re: some user_regdate question

xoops includes a handy function formatTimestamp() which looks like this:

function formatTimestamp($time, $format="l", $timeoffset="")


To Use:
$pretty_time = formatTimestamp($mysqltime);


I give further information about this function here

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

190 user(s) are online (86 user(s) are browsing Support Forums)

Members: 0

Guests: 190

more...

Donat-O-Meter

Stats
Goal: AU$15.00
Due Date: Aug 31
Gross Amount: AU$0.00
Net Balance: AU$0.00
Left to go: AU$15.00
Make donations with PayPal!

Latest GitHub Commits