How to get the records of a day in 30 minute intervals in laravel eloquent

Published

i have question about larave eloquent for get rows of day in the form of (n)min for example
30 min

From 8:00:00 To 8:29:59 :

col1 – col2 – col3

col1 – col2 – col3



From 8:30:00 To 8:59:59 :

col1 – col2 – col3
col1 – col2 – col3






From 23:30:00 To 23:59:59 :

col1 – col2 – col3

col1 – col2 – col3

I actually need to split a day into 30 minute intervals with laravel qeloquent

is there way to do this without loop and mapping with php for better performance in big tables ?
if there is not whats is best way to get result like this . tnx

Source: Laravel

Published
Categorised as database, eloquent, laravel, mysql, php Tagged , , , ,

Answers

Leave a Reply

Still Have Questions?


Our dedicated development team is here for you!

We can help you find answers to your question for as low as 5$.

Contact Us
faq