Solved

Oracle 11g - System Date & Time

Posted on 2013-05-30
4
720 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 73

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 73

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Addition to SQL for dynamic fields 6 38
Help Required 3 97
T-SQL Default value in Select? 5 27
pivot rows to columns 1 19
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

823 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