"What is the time?"
I'm not a native, and, when enquiring about the time, I always say "What time is it", not "What is the time?"
Direct speech: "What time is it?"
Reported speech in the past : He asked what time it was.
Otherwise: He asked: "What time is it?", no shift in tenses because it's...