Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie date conversion question.

Re: newbie date conversion question.

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 28 Jul 1999 13:10:42 -0400
Message-ID: <7nndgm$9jk$1@autumn.news.rcn.net>


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')



--
07/31/1999 01:07:06

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US