Extract hour:min in Excell or MS query

M

MAK

I am trying to fetch data from Oracle using MS Excel via ODBC. Here is
the query I ran on Oracle using SQL*Plus. I want to get the same
result in Excel.


select to_char(dt_time, 'MM/DD HH24'), sum(value)
from tab1
where to_char(dt_time,'Day') not in ('Sunday','Saturday')
group by to_char(dt_time, 'MM/DD HH24')

Thanks in advance for you quick help..

Max.
 
Top