SpyTM Discussion Board

How to get system date from Oracle database using query  

  RSS

Anonymous
 Anonymous
(@Anonymous)
Guest
Joined: 49 years  ago
Posts: 0
29/03/2016 4:22 am  

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.


ReplyQuote
Anonymous
 Anonymous
(@Anonymous)
Guest
Joined: 49 years  ago
Posts: 0
08/04/2016 3:04 am  

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


ReplyQuote

Recent Articles

Share: