| From: | "Robson" <robson-martins(at)bol(dot)com(dot)br> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Urgent - Please, not found date |
| Date: | 2002-06-19 11:48:48 |
| Message-ID: | 004301c21787$467212a0$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 | Brian McCane | 2002-06-19 12:30:40 | Re: index keeps on growing |
| Previous Message | smunoz | 2002-06-19 11:42:23 | Import from text file |