Problemas com Between no FB

Question

Tenho um Banco onde estou tentando executar a seguinte SQL:

SELECT T.NOME
FROM Teste T
WHERE T.DATA BETWEEN 29/01/2005 AND 29/01/2005
ORDER BY T.DATA DESC

e sempre de retorna erro de conversao de string �0�

[]�S Bruno :?:

Gandalf.nho · Answer

Fa�a assim:SELECT T.NOME FROM Teste T WHERE T.DATA BETWEEN �01/29/2005� AND �01/29/2005� ORDER BY T.DATA DESC...

Bfbraz · Answer

[quote:2bdb7cfda6=�gandalf.nho�]Fa�a assim:SELECT T.NOME FROM Teste T WHERE T.DATA BETWEEN �01/29/2005� AND �01/29/2005� ORDER BY T.DATA DESC[/quote:2bdb7cfda6]Da o seguinte erro: Overflow occurred during data type conversion. conversion error from string �29/01/205� :?...

Gandalf.nho · Answer

[quote:27048c8e6c=�bfbraz�][quote:27048c8e6c=�gandalf.nho�]Fa�a assim:SELECT T.NOME FROM Teste T WHERE T.DATA BETWEEN �01/29/2005� AND �01/29/2005� ORDER BY T.DATA DESC[/quote:27048c8e6c]Da o seguinte erro: Overflow occurred during data type conversion. conversion error from string �29/01/205� :?[/quote:27048c8e6c]205 ou 2005?...

Nandolh · Answer

ou utilize a data assim --> �29.01.2005�...

Gandalf.nho · Answer

Agora que li melhor sua mensagem de erro  :oops: , voc� deve usar MM/DD/AAAA e n�o DD/MM/AAAA...

F�rum Problemas com Between no FB #49030