| 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: | Whole Thread | Raw Message | 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 |