CODE EXAMPLE FOR SQL

sql where date today sql

select * from tbl_name 
where cast(datecolumn as Date) = cast(getdate() as Date)

-- or if getdata does not exists
select * from tbl_name 
where cast(datecolumn as Date) = cast(now() as Date)
-- or if date is incompatible with int
select * from tbl_name 
where datecolumn = getdate()