Postgres Pro
Downloads
Home   >   mailing lists

Urgent - Please, not found date - Mailing list pgsql-admin

From Robson
Subject Urgent - Please, not found date
Date
Msg-id 004301c21787$467212a0$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: Heni Lolov
Date:
Subject: Re: create table permission
Next
From: Brian McCane
Date:
Subject: Re: index keeps on growing