SQL>
SQL> create table my_stats_table
2 (object_name varchar2(30),
3 gather_date date default sysdate);
Table created.
SQL>
SQL> select object_name, to_char(gather_date, 'mm/dd/yyyy hh:mi') from my_stats_table
2 /
no rows selected
SQL>
SQL> drop table my_stats_table;
Table dropped.
SQL>