Code:
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Sep 4 11:03:55 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

[email protected]D> select to_char(CREATION_TIME,'DD-MM-RRRR HH24:MM:SS'),name from v$datafile;

TO_CHAR(CREATION_TI NAME
------------------- --------------------------------------------------
23-07-2003 05:07:34 /oradata5/oradata/DTGR02/system01.dbf
23-07-2003 05:07:07 /oradata5/oradata/DTGR02/undotbs01.dbf
23-07-2003 05:07:18 /oradata5/oradata/DTGR02/indx01.dbf
23-07-2003 05:07:20 /oradata5/oradata/DTGR02/tools01.dbf
23-07-2003 05:07:24 /oradata5/oradata/DTGR02/users01.dbf
23-07-2003 06:07:45 /oradata5/oradata/DTGR02/drsys01.dbf
23-07-2003 06:07:47 /oradata5/oradata/DTGR02/xdb01.dbf