Welcome Guest, Not a member yet? Register   Sign In
How to show date rows equals current date?

(This post was last modified: 03-06-2019, 09:06 PM by php_rocs.)


Almost there... add the red part: as d.  I needed to represent the from source as a table.  I named the table d.

select count(employee_id) as count
from (
select employee_id,year,month,
     case when LOCATE('-',multiple) > 0 then substring(multiple,1,locate('-',multiple) - 1)
     else multiple end as 1st_date,
     case when LOCATE('-',multiple) > 0 then substring(multiple,locate('-',multiple) + 1,length(multiple) - locate('-',multiple))
     else multiple end as 2nd_date
from ats_leave_apps
) as d
where DATE(concat(year,'-',month,'-',1st_date)) >= CURDATE() and DATE(concat(year,'-',month,'-',2nd_date)) <= CURDATE()

Messages In This Thread
RE: How to show date rows equals current date? - by php_rocs - 03-06-2019, 09:04 PM

Theme © iAndrew 2016 - Forum software by © MyBB