Re: Oracle timestamp precision
- From: dbaplusplus@xxxxxxxxxxx
- Date: 28 Sep 2005 19:26:23 -0700
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...@xxxxxxxxx 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.
.
- Prev by Date: Re: Can't get env variable from "owa_util.get_cgi_env()"
- Next by Date: database startup problem
- Previous by thread: SAN and multiplexing
- Next by thread: database startup problem
- Index(es):
Relevant Pages
|
