Solved

Oracle 11g - System Date & Time

Posted on 2013-05-30
4
722 Views
Last Modified: 2013-05-30
Hello:

Would like to have the general query command to run against an Oracle 11g database that will provide me the system date and time for the database.  I've used it before, but can't find it.  

"select * from v$instance" does work, but at one time I thought it did.  I'm using SQL Developer to run my queries and usually I have no problems with simple queries.  I've obviously not typing my command correctly.
0
Comment
Question by:akdreaming
  • 2
4 Comments
 
LVL 20

Expert Comment

by:dsacker
ID: 39209318
The SYSDATE may be what you're looking for:

select to_char(SYSDATE, 'Dy DD-Mon-YYYY HH24:MI:SS') as "Current Time"
from dual;

Open in new window

0
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 39209329
select sysdate from dual;  -- to the second

select systimestamp from dual; -- subsecond value with timezone
0
 

Author Closing Comment

by:akdreaming
ID: 39209359
This guy gave two bulls-eye scripts for me to run.  I was able to get what I needed.  First responder provided an error in the script, something to do about "From".  Thanks for the tip.  I'm not an true Oracle DBA, so this is very helpful.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 39209627
dsacker's post should have worked too,  the only difference between that query and mine is he formatted the output as a string where as mine returns the date value in native form, leaving it to the client to interpret/display it.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question