SELECT distinct(PunchDate) FROM Trans_RawProcessDailyData  ORDER BY PunchDate ASC;

orcl>
orcl> select distinct(d) from
  2  (select sysdate d from dual
  3  union all
  4  select sysdate+1/1440 from dual);

D
-----------------
26-10-12 09:07:59
26-10-12 09:08:59

orcl> ed
Wrote file afiedt.buf

  1  select distinct(d) from
  2  (select trunc(sysdate) d from dual
  3  union all
  4* select trunc(sysdate+1/1440) from dual)
orcl> /

D
-----------------
26-10-12 00:00:00

orcl>

select distinct to_char(d, 'dd-mm-yy') 
  from (select sysdate d from dual
         union all
        select sysdate+1/1440 from dual);