sql取时间问题

Question

declare @t table(id int,ddate datetime)insert @t select 1,dateadd(hh,-1,getdate())
insert @t select 2,dateadd(hh,-2,getdate())
insert @t select 3,dateadd(mi,-3,getdate())
insert @t select 4,getdate()
select * 
from @t
select max(ddate)
from @t
/*id          ddate                                                  
----------- ------------------------------------------------------ 
1           2007-12-03 16:51:28.047
2           2007-12-03 15:51:28.047
3           2007-12-03 17:48:28.047
4           2007-12-03 17:51:28.047（所影响的行数为 4 行）
                                                       
------------------------------------------------------ 
2007-12-03 17:51:28.047（所影响的行数为 1 行）
*/

Answer 1

max(convert(DATETIME,"2007-11-1         16:20"))