Thread: Tech Date range SQL querie not working?
View Single Post
Old 08-14-2022, 11:10 AM  
Publisher Bucks
Confirmed User
 
Industry Role:
Join Date: Oct 2018
Location: New Orleans, Louisiana. / Newcastle, England.
Posts: 1,212
Quote:
Originally Posted by Klen View Post
Sample of code which work for me:

PHP Code:
SELECT SUM(`P`) AS 'M' FROM `C` WHERE `DateTime` between '$yy-$mm-$dd 00:00:00' AND '$yy-$mm-$dd 23:59:59' 
Thanks will give that a try now
__________________
Extreme Link List - v1.0
Publisher Bucks is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote