>I have a problem with select records from table.
>There are one record in table mydb.dbo.R_mytable with datetime field
>mydatetime={25.07.2006 12:27}
>
>But SQL-command:
>select * from mydb.dbo.R_mytable where mydatetime between
>convert(datetime,'05.07.2006',104) and convert(datetime,'25.07.2006',104)
>
>not find records.
>
select * from mydb.dbo.R_mytable
where mydatetime >= DATEADD(dd, DATEDIFF(dd, dt, '05.07.2006'), dt)
AND mydatetime < DATEADD(dd, DATEDIFF(dd, dt, '05.07.2006'), dt)+1
--sb--