j[x_] := If[StringMatchQ[x, "TOTAL*"], x, DateList[x]];

tmp4 = DeleteCases[tmp3, {"TOTAL*", __}];

tmp3 = {{"TOTAL*", 1, 2}, {"TOTAL123", 1, 2}, {a, b, c}};

DeleteCases[tmp3, {"TOTAL*", __}]
{{"TOTAL123", 1, 2}, {a, b, c}}

DeleteCases[tmp3, {_String?(StringMatchQ[#, "TOTAL*"] &), __}] (* or *)
DeleteCases[tmp3, {s_String /; StringMatchQ[s, "TOTAL*"], __}]