1 2 Previous Next 16 Replies Latest reply: Dec 1, 2012 6:44 AM by O.Developer Go to original post RSS
      • 15. Re: Date Filed
        951926
        Dear All,

        Please check the following Values.This value will effect the TO_DATE function?

        SQL> SELECT * FROM DATABASE_PROPERTIES;

        PROPERTY_NAME PROPERTY_VALUE
        ------------------------------ ---------------------------------------------------------
        DICT.BASE 2
        DEFAULT_TEMP_TABLESPACE TEMP
        DEFAULT_PERMANENT_TABLESPACE USERS
        DEFAULT_TBS_TYPE SMALLFILE
        NLS_LANGUAGE AMERICAN
        NLS_TERRITORY AMERICA
        NLS_CURRENCY $
        NLS_ISO_CURRENCY AMERICA
        NLS_NUMERIC_CHARACTERS .,
        NLS_CHARACTERSET AR8MSWIN1256
        NLS_CALENDAR GREGORIAN

        PROPERTY_NAME PROPERTY_VALUE
        ------------------------------ ---------------------------------------------------------
        NLS_DATE_FORMAT DD-MON-RR
        NLS_DATE_LANGUAGE AMERICAN
        NLS_SORT BINARY
        NLS_TIME_FORMAT HH.MI.SSXFF AM
        NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
        NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
        NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
        NLS_DUAL_CURRENCY $
        NLS_COMP BINARY
        NLS_LENGTH_SEMANTICS BYTE
        NLS_NCHAR_CONV_EXCP FALSE

        PROPERTY_NAME PROPERTY_VALUE
        ------------------------------ ---------------------------------------------------------
        NLS_NCHAR_CHARACTERSET AL16UTF16
        NLS_RDBMS_VERSION 10.2.0.3.0
        GLOBAL_DB_NAME ORCL10G.REGRESS.RDBMS.DEV.US.ORACLE.COM
        EXPORT_VIEWS_VERSION 8
        DBTIMEZONE 00:00

        27 rows selected.


        Thanks and Regards,
        Fazil
        • 16. Re: Date Filed
          Andreas Weiden
          I would recommend to read the documentation about dates and TO_DATE/TO_CHAR

          As is understand you, you want to compare your date with two other dates.
          If :hr.trdate not between to_date('01/01/2003','dd/mm/yyyy') and to_date('31/12/2099','dd/mm/yyyy') Then
          1 2 Previous Next