If you are asking which rows have a non-midnight time component, then
EFF_END_DT != TRUNC(EFF_END_DT)
is probably best.