$sql="SELECT SUM($dbColName) AS \"SUM\" FROM $table WHERE stationid = $stationId AND". " datetime>=\"$midnightDateGMT $midnightTimeGMT\" AND". " LEFT(datetime,10) <=\"$midnightDate $dayEndTime\" AND sensid=$sensorId";