Re: Date and Time

Sonia Gillespie <sonia_gillespie_at_lagan.com> wrote in message news:950271473.4514.0.nnrp-08.9e9859ae_at_news.demon.co.uk...
> I would like to be able to display time (hh:mi:ss) only in a column in a
> table, and am a bit unsure about how to do this. The column type is date,
> and I am using a stored procedure to enter the data into the table, the
type
> of the data being entered again being date.
>
> I tried formatting the date within the stored procedure using to_date, but
> an error was thrown saying that a numeric was expected.
>
> Could someone enlighten me?

SELECT TO_CHAR(data_col, 'HH24:MI:SS')   FROM table_a
;
--
AJ Allen Received on Fri Feb 11 2000 - 10:20:46 CST