Community /Pin to Profile Bookmark

COUNTing number of dates in a range

@rbraggAug 15.2007

If I have date/time stored in my db from now() as tinytext, how can I write SELECT statements to find COUNTs?

For example, I have these stored in the db:

2007-08-05 13:50:08
2007-08-08 16:11:40
2007-08-09 15:01:14

And I would like to find the number of dates between August 5th and August 8th. Is this impossible?

to post a comment

1 Comments(s) _↴

@stephan_gerlachAug 16.2007 — #Not sure if you can do it with tinytext but you can do it with datetime fields.

Should be something like this

[code=php]
 
 $sql = 'SELECT count(*) as total FROM tablename WHERE date>'.$minDate.' && date<'.$maxDate;
 
 [/code]

Also in #PHP _↴

UNIX-commands in PHP code?Echo prepared statement Table insert not working

×

Success!

Help @rbragg spread the word by sharing this article on Twitter...

about: ({
version: 0.1.9 — BETA 5.21,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});

changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...

recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...