Postgres Pro
Downloads
Home   >   mailing lists

Help - Not found date - Mailing list pgsql-admin

From Robson
Subject Help - Not found date
Date
Msg-id 000e01c21783$2891e5c0$543c620a@catnet.com.br
Whole thread Raw
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: "girija nagaraj"
Date:
Subject: he "pg_encoding_to_char" error
Next
From: smunoz@miroal.com
Date:
Subject: Import from text file