Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number into Time Format
Thanks for the input.
On Thu, 07 Dec 2000 08:23:36 +0100, Stephan Langer <slanger_at_dixi-wc.de> wrote:
>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 - 07:43:49 CST