SELECT statement and time format

[JeffM]

I have a table with:
time DATE,
as a data item and have inserted values, example:
(..., TO_DATE('08:00 AM', 'HH:MI AM'), ...);
When I select 'time', I receive output:
TIME
---------
01-FEB-01

...instead of having a time value returned. My question is this: How can
I structure my SELECT statement so that the data returned from my time column
is formatted as 'HH:MI am' ?

[Kotta Satyamurthy]

"JeffM" <urm_the_mad@yahoo.com> wrote:
>
>I have a table with:
>time DATE,
>as a data item and have inserted values, example:
>(..., TO_DATE('08:00 AM', 'HH:MI AM'), ...);
>When I select 'time', I receive output:
>TIME
>---------
>01-FEB-01
>
>...instead of having a time value returned. My question is this: How can
>I structure my SELECT statement so that the data returned from my time column
> is formatted as 'HH:MI am' ?
>

[Kotta Satyamurthy]

hey Jeff,

you can do something like this :

1 select to_CHAR(sysdate,'HH:MM:SS')
2* FROM DUAL
SQL> /

TO_CHAR(
--------
05:02:24



"JeffM" <urm_the_mad@yahoo.com> wrote:
>
>I have a table with:
>time DATE,
>as a data item and have inserted values, example:
>(..., TO_DATE('08:00 AM', 'HH:MI AM'), ...);
>When I select 'time', I receive output:
>TIME
>---------
>01-FEB-01
>
>...instead of having a time value returned. My question is this: How can
>I structure my SELECT statement so that the data returned from my time column
> is formatted as 'HH:MI am' ?
>