Re: BUG #1653: Bug in date

Negative, i know what the to_date do.

See the "dt_transacao _/*<=*/_ to_date("

The <= make the first sql equal to second

Second: "dt_transacao _/*<*/_ to_date('02042005000000')"

Guilherme Silva
Programador - Planejamento
E-mail: guilherme(dot)silva(at)nexxera(dot)com
Tel/Fax: +55 48 2106-5698
ICQ: #119540871
http://www.nexxera.com
NEXXERA Tecnologia e Serviços S.A.
"Seu ambiente eletrônico de negócios"

Tom Lane wrote:

>"Guilherme" <guilherme(dot)silva(at)nexxera(dot)com> writes:
>
>
>>BILHETAGEM=# select sum(tm_arquivo) from bilhete where
>>cd_caixa_postal_principal=1304 AND
>>BILHETAGEM-# dt_transacao >= to_date('01042005000000', 'ddmmyyyyHH24MISS')
>>AND
>>BILHETAGEM-# dt_transacao <= to_date('01042005235959', 'ddmmyyyyHH24MISS');
>>
>>
>
>to_date() produces a date, not a timestamp. I suspect you are after
>to_timestamp. If dt_transacao is a timestamp, the above will only
>select rows that are at exactly midnight of 2005-04-01, because that's
>what the date values will promote to.
>
> regards, tom lane
>
>
>