Added notes to prefer use to_time instead of to_datetime

After discussion in #10196: added method documentation/note to prefer use of `to_time` instead of `to_datetime`

cc: @pixeltrix