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('0204200500')"
Guilherme Silva
Programador - Planejamento
E-mail: [EMAIL PROTECTED]
Tel/Fax: +55 48 2106-5698
ICQ: #119540871
http://www
I understand you, sorry my english is too bad, ignore the last email.
I will try use to_timestamp.
Thanks.
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ônic
Guilherme Silva <[EMAIL PROTECTED]> writes:
> Negative, i know what the to_date do.
I don't think you do, because you are feeding it input that it will
ignore --- the hh/mm/ss fields are just being thrown away.
regression=# select to_date('0104200500', 'ddmmHH24MISS');
to_date
-
"Guilherme" <[EMAIL PROTECTED]> writes:
> BILHETAGEM=# select sum(tm_arquivo) from bilhete where
> cd_caixa_postal_principal=1304 AND
> BILHETAGEM-# dt_transacao >= to_date('0104200500', 'ddmmHH24MISS')
> AND
> BILHETAGEM-# dt_transacao <= to_date('01042005235959', 'ddmmHH24MISS');
to_
