zzgzyyz 发表于 2016-10-31 05:15:04

SQL SERVER

　　

SELECT DATEADD(SECOND,AVG(DATEDIFF(SECOND, 0, CAST(MyDateTimeColumn as TIME))), 0)
FROM MyTable
　　
页: [1]
查看完整版本: SQL SERVER