MSSQL Stored Procedure -> datetime vergleichsprobleme???

[cherry]

SQL-Code:

declare
  @date_time datetime
SET @date_time = CAST('2008-05-07 15:16:32.000' AS datetime);
SELECT folder_size FROM [t_bb_folder_info]
where [t_bb_folder_info].[date_time] Between DateAdd(hour,-1,@date_time) and DateAdd(hour,1,@date_time)

gibt mir keinen einzigen datensatz zurück...
obwohl

SQL-Code:

declare
  @date_time datetime
SET @date_time = CAST('2008-05-07 15:16:32.000' AS datetime);
SELECT DateAdd(hour,-1,@date_time), DateAdd(hour,1,@date_time), [t_bb_folder_info].[date_time] FROM [t_bb_folder_info]

folgendes zurück gibt:

SQL-Code:

2008-07-05 14:16:32.000 ¦ 2008-07-05 16:16:32.000 ¦ 2008-05-07 15:16:32.000
2008-07-05 14:16:32.000 ¦ 2008-07-05 16:16:32.000 ¦ 2008-05-07 15:16:32.000
2008-07-05 14:16:32.000 ¦ 2008-07-05 16:16:32.000 ¦ 2008-05-07 15:16:32.000
2008-07-05 14:16:32.000 ¦ 2008-07-05 16:16:32.000 ¦ 2008-05-07 15:16:32.000
.
.
.