To extract just the date component, you could:

select trunc(datecolumn) from T;

Trunc by default will removing the time component, you can trunc dates to many different levels -- hours, days, weeks, months, years and so on.

You could also just:

select to_char( datecolumn, 'dd-mon-yyyy' ) from t;

that is, use a date format to retrieve just the component of the date you were interested in.

As for the time component, it'll be very similar. For example:


select to_number(to_char(datecolumn,'sssss')) from T;

will return only the time component of the date as the number of seconds since midnight. Alternately, you may:

select to_number(to_char(datecolumn,'hh24')) hours,
to_number(to_char(datecolumn,'mi')) minutes,
to_number(to_char(datecolumn,'ss')) seconds
from T;

to get the hours, minutes, seconds in the time component in three fields.

There are many formats and functions you may apply to dates to perform these operations, the above are just a few and the most common. For more see

</code> http://docs.oracle.com/cd/F49540_01/DOC/server.815/a67779/function.htm#1028572 <code>

date functions and formats are documented there.