Re: question about timestamp precision....

On Wed, 28 Sep 2005 18:40:26 -0700, leodippolito interested us by writing:

>
> Hello sirs,
>
> I have this SQL statement:
>
> DELETE FROM EMODPRODUTOS
> WHERE (CdProduto = 105) AND
> (DtUltAlteracao = to_timestamp('28/09/2005 21:50:13,141233'))
>

Try using an appropriate PIC format. For example - as shown in the SQL Language Manual, under the to_timestamp() description, they give the following:

    TO_TIMESTAMP('10-SEP-0214:10:10.123000','DD-MON-RRHH24:MI:SS.FF') and you may note a few differences to your statement.

Further I can not comment, as you have not provided your Oracle or OS version, nor your NLS information, and I'd be guessing to the settings. (Hint: the comma separator is throwing me off.)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***