Re: Oracle timestamp precision

I think by default time format is good only up to millisecond. However, you can override default by explictly specifying second argument (format) tin to_timestamp. You can search on metalink or in Oracle manuals the exact format...

to_timestamp(arg1, 'DD/MM/YYYY HH24:MI:SSx.....')

leodippol..._at_gmail.com wrote:
> 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 - 21:26:23 CDT