Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle timestamp precision
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:43:24 CDT
![]() |
![]() |