Learned some SQL*Plus formating commands

trunc(date)/trunc(number)
column io_date format a12
e.g
select to_char(snap_time,'yyyy-mm-dd') io_date,
...
group by to_char(snap_time,'yyyy-mm-dd')

also learned functions round and ceil .
^-^