Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbie date conversion question.
this message was emailed to Jorge Torralba at
<379F2B37.8390B5C8_at_Intel.Com>...
Hi Jorge,
Yes, just issue the command:
TO_CHAR((SYSDATE+2.5),'MM/DD/YYYYHH24:MI:SS')
regards
Jerry Gitomer
Jorge Torralba wrote in message <379F2B37.8390B5C8_at_Intel.Com>...
>Is there a way to convert a decimal to a date ? Such as
converting 2.5
>to 60:00:00 or 2 Days 12 Hours 0 minutes .
>
>Thanks,
>
>Jorge
>
>
Received on Wed Jul 28 1999 - 12:10:42 CDT