Posts by f3107 • 31 points
4 posts
-
0
votes1
answer85
viewsQ: How to query multiple select in only one sql line to get 7 daily result
SELECT count(*) as dias FROM users WHERE DATE(created_at) = CURRENT_DATE()-0 I have this sql line that sums all records made of the current day. But I want of the 7 days in a row would have like to…
-
0
votes1
answer82
viewsQ: select return results without repeating reply
I have the following query SELECT (SUM(DISTINCT result)/COUNT(*))as total, uf FROM users WHERE result > 0 and result IS NOT NULL GROUP BY uf ORDER BY total DESC LIMIT 5 I want to select all 5…
-
1
votes1
answer65
viewsA: How to disable previous hours of the current with javascript datetimepicke
I found a solution I will leave it here in which and only add a method minDateTime: 0 <script> $(document).ready(function(e) { $.datetimepicker.setLocale('pt-BR'); $("#hora").datetimepicker({…
-
0
votes1
answer65
viewsQ: How to disable previous hours of the current with javascript datetimepicke
I have a calendar that works correctly that eliminates weekends, but I also wanted for example: now it is 11 hours so all previous times were disabled so it is not possible to select.…