This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Dec 1, 2012 4:44 AM by O.Developer Go to original post RSS
  • 15. Re: Date Filed
    951926 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points