Thread: Urgent - Please, not found date

Urgent - Please, not found date

From

"Robson"

Date:

19 June 2002, 10:49:50

Date exist in database.

What err:

SELECT T01.Operador, T01.Data, T01.Hora, T01.TipoCli, T01.Cliente, T01.Contato, T01.Cidade, T01.UF, T01.DDD, T01.Fone, T01.Observacoes, T01.Valor, T01.IsCliInic, T01.Produto, T01.Motivo, T01.Resultado, T01.Promocao, T01.ProdPromo1, T01.ProdPromo2, T01.ProdPromo3, T01.ProdPromo4, T01.Sexo, T01.FaixaEtaria FROM LigTmkt T01 WHERE (T01.Data = cast('13/05/2002' as date))

OR

SELECT T01.Operador, T01.Data, T01.Hora, T01.TipoCli, T01.Cliente, T01.Contato, T01.Cidade, T01.UF, T01.DDD, T01.Fone, T01.Observacoes, T01.Valor, T01.IsCliInic, T01.Produto, T01.Motivo, T01.Resultado, T01.Promocao, T01.ProdPromo1, T01.ProdPromo2, T01.ProdPromo3, T01.ProdPromo4, T01.Sexo, T01.FaixaEtaria FROM LigTmkt T01 WHERE (T01.Data iLike cast('13/05/2002' as date))

Regards,

Robson