| From: | "Robson" <robson(at)opeco(dot)com(dot)br> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Help - Not found date |
| Date: | 2002-06-19 11:19:17 |
| Message-ID: | 000e01c21783$2891e5c0$543c620a@catnet.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | smunoz | 2002-06-19 11:42:23 | Import from text file |
| Previous Message | Jean-Christophe ARNU (JX) | 2002-06-19 09:09:00 | index keeps on growing |