Geometric and subgeometric convergence of diffusions with given stationary distributions, and their discretizations