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.

Please help.