2
I have a field timestamp and I need to create an interval every 15 minutes.
How in Sql I should do this ?
Data = YYYY/MM/DD HH:MM:SS
The purpose is an analysis where I need the amount of products sold every 15 minutes the day before.
0No answers
Browser other questions tagged sql database business-intelligence netezza
You are not signed in. Login or sign up in order to post.
Would it be a group by every 15 minutes? If so, try GROUP BY FLOOR(
data/ 100) % 10000 *15– Wagner Soares
It would be a group by every 15 minutes and day. I will try this solution.
– Andre Gomes
What did you try to do? is which database is sql server or mysql?
– Marco Souza
would be something like date/time units 29/9/16 00:15 17 29/9/16 00:30 45 29/9/16 00:45 67 ... 29/9/16 15:15 117 ?
– Motta
I think contradictory tags are missing.
– Eric Wu
Hello Mota, it’s actually in Neteza but here doesn’t have the tag, that’s why I put the two comics. It is an OLAP report where I need to measure every 15 minutes per day. 20:00 - 20:15 - 20:30 and etc. Thank you.
– Andre Gomes