Hi Sayan, I created the column as timestamp(6) with time zone... SQL> desc movimento_canina; Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER(38) ID_ANIMALE NOT NULL NUMBER(38) COD_TIPO_MOVIMENTO_ENTRATA NVARCHAR2(4) DATA_ENTRATA NOT NULL DATE ID_UA_PROPRIETARIO NOT NULL NUMBER(38) ID_UA_DETENTORE NUMBER(38) COD_TIPO_MOVIMENTO_USCITA NVARCHAR2(4) DATA_USCITA DATE DATA_INVIO_ENTRATA TIMESTAMP(6) WITH TIME ZONE DATA_INVIO_USCITA TIMESTAMP(6) WITH TIME ZONE ID_OPERATORE NUMBER(38) TS_ULTIMA_MODIFICA NOT NULL TIMESTAMP(6) WITH TIME ZONE NOTE NVARCHAR2(1000) ID_BDN_ENTRATA NUMBER(38) ID_BDN_USCITA NUMBER(38) On 04/17/2013 03:30 PM, Sayan Sergeevich Malakshinov wrote: > May be fractional_seconds_precision more than 6? > For example timestamp(9) > > Best regards, > Sayan Malakshinov > http://orasql.org > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l