select to_char(date_col,'YYYYMMDDHH24MISS') from table;