Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number into Time Format
correct the syntax to:
to_char(trunc(sysdate) + 1.5 / 24, 'HH24:MI')
hth
Stephan
NeedaHoliday schrieb:
> I tried the following and got 00:00 . I was looking for 1:30.
>
> On Wed, 06 Dec 2000 03:28:16 GMT, Alex Filonov <afilonov_at_pro-ns.net>
> wrote:
>
> >to_char(to_date(trunc(sysdate) + 1.5 / 24, 'HH24:MI')
Received on Thu Dec 07 2000 - 01:23:36 CST