Non-stochasticity of time-dependent quadratic Hamiltonians and the spectra of canonical transformations