Posted by Ross Presser on 07/22/05 00:14

On Thu, 21 Jul 2005 18:07:49 +0000 (UTC), Erland Sommarskog wrote:

> Anyway, the best way to strip out the time component is:
>
> convert(char(8), getdate(), 112)

that leaves you with a char value. I prefer

convert(datetime, floor(convert(float,getdate())))

even though it's a bit wordier, because it can't possibly be sensitive to
the region, and also because it has useful variants. Like this, which
rounds a time down to the start of the hour:

convert(datetime, floor(convert(float,getdate()) * 24) / 24)

• Next in forum: Re: Auditing user and security related activities in SQLServer
• Prev in forum: Re: mmx.exe as encountered a problem and as to close
• Thread view: Re: WHAT DO I USE TO MAKE A TODAY DATE QUERY?

[Reply to this message]