to_char(gather_date, 'mm/dd/yyyy hh:mi') : TO_CHAR « Date Timestamp Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Date Timestamp Functions
3. TO_CHAR

SQL>
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>
SQL>