<div>
The SYSDATE may be what you're looking for:<br />
<br />

<pre><code id="code-20-39209318-1">select to_char(SYSDATE, 'Dy DD-Mon-YYYY HH24:MI:SS') as &quot;Current Time&quot;
from dual;</code></pre>
</div>


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;

<div>
This guy gave two bulls-eye scripts for me to run. &nbsp;I was able to get what I needed. &nbsp;First responder provided an error in the script, something to do about &quot;From&quot;. &nbsp;Thanks for the tip. &nbsp;I'm not an true Oracle DBA, so this is very helpful.
</div>


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.

<div>
dsacker's post should have worked too, &nbsp;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.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hello:<br />
<br />
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. &nbsp;I've used it before, but can't find it. &nbsp;<br />
<br />
&quot;select * from v$instance&quot; does work, but at one time I thought it did. &nbsp;I'm using SQL Developer to run my queries and usually I have no problems with simple queries. &nbsp;I've obviously not typing my command correctly.
</div>
</div>


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.

Oracle 11g - System Date &amp; Time

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Oracle 11g - System Date &amp; Time

Oracle 11g - System Date & Time