Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB STARTUP TIME

782482Jul 20 2010 — edited Jul 20 2010

Hi
When i query my database to find the db startup time i get

SELECT to_char(startup_time,'DD-MON-YYYY HH24:MIS') "DB Startup Time"
FROM sys.v_$instance

I get the following error

ERROR at line 1:
ORA-01821: date format not recognized

What to do?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2010

Added on Jul 20 2010

#general-database-discussions

3 comments

30,185 views