Problem With Datatime

Hi everybody.
I am new in SQL SERVER and I have a problem with a datetime

I have a select. It works in a database but
it doesn´t work in other database.

The error is the next :

2004-04-20 13:37:32,781 INFO [STDOUT] ConexionBDExceptionjava.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

The select is:

SELECT id_solicitud from solicitudes where
fecha_apertura >= '01/03/04'
AND fecha_apertura <= '31/03/04 23:59:59.999'
ORDER BY fecha_apertura DESC

Thanks for attention.
PILAR