try with this:
select to_char(open_time,'dd.mm.yyyy hh24:mi:ss') from v$thread;
----- Original Message -----
From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Thursday, August 17, 2000 1:34 PM
Subject: open_time in v$thread
> Hi Folks,
>
> I've noticed that open_time field in v$thread is varchar2(20) in V7.3
Oracle
> but in 8.0.5 it's a Date format field. The net result is that with 8.0.5
> you only see date but not time that database was opened. Does anyone know
> if the "time" titbit of information is available from some other view?.
>
> Sean :)
>
> ###### ###### ###### ######
> # # # # # # # # Rookie
> #### # # ###### ###### Data
> # # # # # # # # Base
> # # ####### ###### # # Adminstrator
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>
> The only man who never makes a mistake is the man who never does anything.
> - Theodore Roosevelt
>
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Aug 17 2000 - 06:55:35 CDT
