get todays date and a certain time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AKorsakova@gmail.com - 27 Sep 2006 19:36 GMT

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

Reply to this Message

Razvan Socol - 28 Sep 2006 05:43 GMT

You can use DATEADD, for example:

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

Razvan

> Hi Everyone,
>
[quoted text clipped - 7 lines]
> Thanks in advance,
> Anna

Reply to this Message

Hugo Kornelis - 29 Sep 2006 00:00 GMT

>Hi Everyone,
>
[quoted text clipped - 4 lines]
>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.

Signature

Hugo Kornelis, SQL Server MVP

Reply to this Message