Management want to count the number of nodes added in the last 2 months. I think this is what they want, but it returns 0
select count(node_name) from nodes where (cast((date(reg_time)-current_date)days as decimal) <= 60) What did I do wrong?
Management want to count the number of nodes added in the last 2 months. I think this is what they want, but it returns 0
select count(node_name) from nodes where (cast((date(reg_time)-current_date)days as decimal) <= 60) What did I do wrong?