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: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
