some user_regdate question [Q and A] - XOOPS Web Application System

XOOPS

Forum

Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk

some user_regdate question

2004/10/6 19:44
smdcom
Posts: 901
Since: 2004/4/27

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...

Re: some user_regdate question

2004/10/6 19:50
ackbarr
Posts: 1449
Since: 2002/10/2

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

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Sep 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

some user_regdate question

Re: some user_regdate question

Login

Search

Recent Posts

Re: sbadmin5 - Bootstrap 5 Theme

Re: sbadmin5 - Bootstrap 5 Theme

sbadmin5 - Bootstrap 5 Theme

Re: XoopsFaq for 2.5.10

XoopsFaq for 2.5.10

Re: activate block by default

Re: wgFilemanager released for testing and contribution

Re: wgFilemanager released for testing and contribution

Re: activate block by default

activate block by default

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}