MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

How count no of occurences between two days, 15 min interval,1 min interval
Posted by: Suresh Reddy
Date: November 02, 2015 10:14PM

I have table like

DATE_TIME NAME
2014-12-01 12:15:00 S1
2014-12-01 12:30:00 S1
2014-12-01 12:45:00 S1
2014-12-01 01:45:00 S1

2014-12-31 23:55:00 S2
2014-12-31 23:56:00 S2
2014-12-31 23:57:00 S2
2014-12-31 23:58:00 S2
2014-12-31 23:59:00 S2
2015-01-01 00:00:00 S2
2015-01-01 00:05:00 S2

How to calculate granularity(pattern of DATE_TIME) and expected count like if we observe DATE_TIME intervals are missing for S1 & S2

NAME GRANULARITY eXPECTED_COUNT
S1 15 mins 7
S2 1 MIN 11

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How count no of occurences between two days, 15 min interval,1 min interval
Suresh Reddy
November 02, 2015 10:14PM
Re: How count no of occurences between two days, 15 min interval,1 min interval
Peter Brawley
November 03, 2015 10:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.