Oracle timestamp precision

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.

.

Relevant Pages

  • question about timestamp precision....
    ... DELETE FROM EMODPRODUTOS ... date format picture ends before converting entire input ...
    (comp.databases.oracle.misc)
  • Re: CR & Tab in VB 2005 Textbox
    ... Secondly the CStr is converting as you saw to a string with that value. ... I do this since I use both VB and C# and sometimes I need to use code and if I use the Dot.Net functions provided by the objects rather than the VB it is easier to convert since it is mostly getting rid of ending semi colons and changing square brackets into regular brackets. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Unicode String Parameters in DLLs
    ... > NOT Unicode, so you might have heard some stuff about that. ... > One thing to watch out for is if your DLL routine puts a zero byte at the ... > string ); it does not terminate the string. ... >> We are converting our application to work with Unicode. ...
    (microsoft.public.word.vba.general)
  • Re: error passing byte[] or strings of encrypted data to Web Service
    ... Converting Base64 should fix it. ... > this should be done automatically upon serialization by the proxy ... >> XML string is in fact a well-formed XML: ...
    (microsoft.public.dotnet.security)
  • Re: Precision problem
    ... > so that i am converting it to string using gcvtand sprintfetc. ... > After this some precision loss is happening. ... floating point value that's turning out different from your expectations, ...
    (microsoft.public.vc.mfc)