Home Forums Database Administrators How to get system date from Oracle database using query

  • Author
    Posts
  • Lina
    Post count: 0

    Using SQL query, how to fetch the system date from Oracle database?
    and is it possible to get the date in specific format like “YYMMDD” or “DDMMYY”?
    please explain in detail since I am very new to database queries.
    I am writing a shell script to check database connectivity and I need this information to fetch the database date and to compare it with UNIX system date.

  • Scott Paul
    Post count: 0

    DDMMYY – select to_char(sysdate,’DDMMYY’) from dual;
    YYMMDD – select to_char(sysdate,’YYMMDD’) from dual;

    Like above example, change the string ‘DDMMYYYY’ as required.

    DD – Day
    MM – Month
    YY – Year

Reply To: How to get system date from Oracle database using query
Your information: