There is no ideal time of the day unless you are following any diet or on intermittent fasting. Collagen is pure protein so it won't play with blood glucose, for example. It supports any physical activity, so some would take it within 30 minutes post physical activity to maximise their anabolic window.