Re: to_date format not working...

From: Tom Leary <tleary1_at_uswest.net>
Date: Mon, 4 Dec 2000 15:39:47 -0800
Message-ID: <_8UW5.782$%L.231252@news.uswest.net>

You need to cast it to a date, then back to charTO _CHAR( TO_DATE(substr(time, 1, 4), HH24MI), HH24:MI) || '-' | TO_CHAR( TO_DATE(substr(time, 5, 4), HH24MI), HH24:MI)

HTH, DBA Tom

"Roy D. Mercer" <wb5wzm_at_flash.net> wrote in message news:4OTW5.26520$6W1.1565809_at_news.flash.net...
> I have a column called time and set up as varchar2(8). It stores the time
as
> 08001700. When I create the report I want the time shown in this format:
> 08:00-05:00pm. I have not been able to get this format to work
> successfully. I appreciate any help given. Thanks.
>
>
Received on Mon Dec 04 2000 - 17:39:47 CST