select * ,dateadd(day,FLOOR(cast((end_date-start_date) as int)/2),start_date) as min_date from (select getdate() as start_date,DateAdd(day,4,getdate()) as end_date )a
select * ,dateadd(day,FLOOR(cast((end_date-start_date) as int)/2),start_date) as min_date from (select getdate() as start_date,DateAdd(day,4,getdate()) as end_date )a/* start_date end_date min_date --------------------------------------------------------------- 2004-05-01 22:43:38.820 2004-05-05 22:43:38.820 2004-05-03 22:43:38.820*/
思路同internetcsdn(公元1979年8月10日) 兄SELECT CAST(AVG(CAST(日期 AS INT)) AS DATETIME) AS DateAverage FROM 表
from (select getdate() as start_date,DateAdd(day,4,getdate()) as end_date
)a
from (select getdate() as start_date,DateAdd(day,4,getdate()) as end_date
)a/*
start_date end_date min_date
---------------------------------------------------------------
2004-05-01 22:43:38.820 2004-05-05 22:43:38.820 2004-05-03 22:43:38.820*/
FROM 表