Technical Article

Today w/o 00:00:00:000

,

Here is another way to get the value of today without the time portion.

select 
  cast(convert(varchar(10),getdate(),101) as datetime) as theDate

Rate

Share

Share

Rate