sql日期不变动态生成时分秒

SELECT  DATEADD(second,ABS(CHECKSUM(NEWID()))%DATEDIFF(second,'20190901','20190901 23:59:59'),'20190901')