[ILUG] [OT] oracle again..... result format

[Paul Jakma]

if i do:

select foo from bar where dongle=999;

and foo is of type DATE, i get:

18-MAR-01

my question is? does a DATE type store the time of day too, and if so,
how do i get it to print it?

tried time(foo), but no joy...

ta in advance,

paul jakma.