Would method 1 be reliable even in the early morning hours? As SYSDATETIME() is non-deterministic, could it not use two slightly different values for the two calls?

I get the feeling that you, Tom, considered that and have an explanation of the definition of "deterministic."