Get specific time from getdate()

Question

I'm facing an issue when trying to add a condition in my sql request
I want add a condition i.e date between DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) and current date until 23:59:59.
How can I specify the second part of condition?
thank you.

possible duplicate of [Get row where datetime column = today - SQL server noob](http://stackoverflow.com/questions/2583228/get-row-where-datetime-column-today-sql-server-noob) — Patrick Hofman, Sep 21 '15 at 10:47

score 2 · Accepted Answer · answered Sep 21 '15 at 10:47

2

You can do with predicate:

someDate < dateadd(dd, 1, cast(getdate() as date))

answered Sep 21 '15 at 10:47

Giorgi Nakeuri

35,155
8
47
75

score 0 · Answer 2 · answered Sep 21 '15 at 10:49

0

I usually go with the following:

somedate >= cast(floor(cast getdate() as float) as datetime) and somedate < cast(ceiling(cast getdate() as float) as datetime)

answered Sep 21 '15 at 10:49

KaraokeStu

758
7
17

Seems more complicated than it needs to be. – Dan Bracuk Sep 21 '15 at 11:02
I find his is a safer way, and is backwards compatible - the "date" type didn't use to exist! – KaraokeStu Sep 21 '15 at 13:51

Get specific time from getdate()

2 Answers2