Get system date from Oracle database using query
Using SQL query, how to fetch the system date from Oracle database?
and is it possible to get the date in specific like “YYMMDD” or “DDMMYY”?
please explain in detail since I am very new to database queries.
I am writing a shell script to database connectivity and I need this information to fetch the database date and to it with UNIX system date.
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
Leave a reply