3shTech

    3shTech (trainings@trishtechnology.com) String Functions Numeric Functions Group Functions Date Functions Analytical Functions Conversion Functions These functions are used to convert the values from one type to anther type. Types:- ·        TO_NUMBER ·        TO_CHAR ·        TO_DATE ·        Other Conversion Functions ·        BIN_TO_NUM ·        CHARTOROWID ·        ROWIDTOCHAR   Conversion Rules between data types:-   Data Type    Char      Num      Date Char — Yes     Yes Num Yes —     Not Applicable Date Yes Not Applicable    ...

  3shTech (trainings@trishtechnology.com) String Functions Numeric Functions Group Functions Date Functions Analytical Functions Date Functions ·        Oracle default date format is DD-MON-YYYY. ·        We can change the default format to our desired format by using the following command. But this will expire once the session was closed. SQL>ALTER SESSION SET NLS_DATE_FORMAT = ‘DD-MONTH-YYYY’; Below are the Oracle   DATE FUNCTIONS   used to manipulate the date values:-   ·        SYSDATE ·        CURRENT_DATE ·        CURRENT_TIMESTAMP ·        SYSTIMESTAMP ·        LOCALTIMESTAMP ·        DBTIMEZONE ·        SESSIONTIMEZONE ·        TO_CHAR ·    ...