I don't think any date functions return a decimal.
Either of these might work.
SELECT TOP 100 [name], create_date,
DATEPART(hour, create_date),
DATEPART(minute, create_date)
FROM SYS.OBJECTS
WHERE CONVERT(TIME(0), create_date) > '16:30:00';
SELECT TOP 100 [name], create_date,
DATEPART(hour, create_date),
DATEPART(minute, create_date)
FROM SYS.OBJECTS
WHERE (DATEPART(hour, create_date) = 16 AND DATEPART(minute, create_date) >= 30 AND DATEPART(second,create_date) >0)
OR ( DATEPART(hour, create_date) > 16);
- This reply was modified 2 years, 7 months ago by Ed B.