Explanation

He came home at midnight.

****

We use "at" to specify a particular point in time

Both noon and midnight are very short periods.

We would therefore say: at midnight or at noon.