sql - Get specific time from getdate() -


i'm facing issue when trying add condition in sql request
want add condition i.e date between dateadd(day, datediff(day, 0, getdate()), 0) , current date until 23:59:59.
how can specify second part of condition?
thank you.

you can predicate:

somedate < dateadd(dd, 1, cast(getdate() date)) 

Comments

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

python - RuntimeWarning: PyOS_InputHook is not available for interactive use of PyGTK -