Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> question about timestamp precision....

question about timestamp precision....

From: <leodippolito_at_gmail.com>
Date: 28 Sep 2005 18:40:26 -0700
Message-ID: <1127958026.752115.274680@g49g2000cwa.googlegroups.com>

Hello sirs,

I have this SQL statement:

DELETE FROM EMODPRODUTOS
WHERE (CdProduto = 105) AND
(DtUltAlteracao = to_timestamp('28/09/2005 21:50:13,141233'))

But it's not working........ I get:

ORA-01830: date format picture ends before converting entire input string

I need a where clause with a timestamp value with this precision...

Can oracle handle this?

I appreciate any information. Received on Wed Sep 28 2005 - 20:40:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US