gmt_date >= YEAR(getdate())+'-'+MONTH(getdate())+'-'+DAY(getdate())
AND gmt_date < YEAR(getdate())+'-'+MONTH(getdate())+'-'+DAY(getdate()-1)
AND gmt_date < YEAR(getdate())+'-'+MONTH(getdate())+'-'+DAY(getdate()-1)
gmt_date >= convert(varchar(10), YEAR(getdate()))+'-'+convert(varchar(10), MONTH(getdate()))+'-'+convert(varchar(10), DAY(getdate()))
AND gmt_date < convert(varchar(10), YEAR(getdate()))+'-'+convert(varchar(10), MONTH(getdate()))+'-'+convert(varchar(10), DAY(getdate())-1)
gmt_date >= convert(varchar(10), YEAR(getdate()))+'-'+convert(varchar(10), MONTH(getdate()))+'-'+convert(varchar(10), DAY(getdate())-1)
AND gmt_date < convert(varchar(10), YEAR(getdate()))+'-'+convert(varchar(10), MONTH(getdate()))+'-'+convert(varchar(10), DAY(getdate()))