Posted by Hugo Kornelis on 11/27/37 11:59

On 27 Sep 2006 11:36:59 -0700, AKorsakova@gmail.com wrote:

>Hi Everyone,
>
>I am trying to write something to give me back all the data for a
>sertain time range for today.
>So for example: I need to get all records where change_date is <= today
>2pm and > today at 8pm.
>I know i can get just the date for today by using
>CONVERT(CHAR(10),getdate(),102) but can i add a time range to that?

Hi Anna,

Use either

CONVERT(datetime, CONVERT(CHAR(10), getdate(), 126) + 'T14:00:00')

or

DATEADD(day, DATEDIFF(day, 0, getdate()), '14:00:00')

to get current date with a time of 2PM.

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Unexpected Casting With Sum & Coalesce
• Prev in forum: Re: store db objects in *.ndf vs. *.mdf??
• Thread view: Re: get todays date and a certain time

[Reply to this message]