Re: comparing datetime

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
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l