How to get the details from a table in databse to send as an attachment through email.
Database table consists of c_Date,Eid,Intime,Outtime,Estatus,Count columns.
I need to fetch the all the columns where Estatus='in' and c_Date is today.
select * from table where Estatus='in'
whats the command for checking today's date with c_Date.