Posted by AKorsakova on 09/25/19 11:59

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?

Thanks in advance,
Anna

• Next in forum: Re: Update Query Help!!
• Prev in forum: Re: Non English Characters
• Thread view: get todays date and a certain time

[Reply to this message]