I have a stored procedure that takes a
datetime parameter. I need to determine if the given
datetime parameter includes the time.
DATEPART(hour, @datetimeValue) = 0 doesn't work in my case because the datetime can be provided as
3/14/2019 0:00 which refers to as 12 AM and valid.
Return true if input is :
'3/14/2019 0:00' '3/14/2019 15:00'
Return false only if input has no time :
Thanks everyone for their input. It looks there is no solution to this other than changing the store proc parameter to varchar.