Posted by Razvan Socol on 11/28/89 11:59

You can use DATEADD, for example:

SELECT DATEADD(hour,14,CONVERT(CHAR(10),getdate(),102))

Razvan

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?
>
> Thanks in advance,
> Anna

• Next in forum: Insert Japanese from ASP page into MSSQL Server 2000 database
• Prev in forum: Re: Q on joining tables with nullable fields
• Thread view: Re: get todays date and a certain time

[Reply to this message]