I believe that would be simplier to do :
select CALL_START +
to_date(to_char(CALL_START,'DD/MM/RRRR')||' '||
CALL_DURATION,'DD/MM/RRRR HH24:MI:SS') result
from
TABLE_WHITH_DATA;
Making the table queriable.
Regards,
Alex
On 16 abr, 04:38, sonty <[email protected]> wrote:
> select CALL_START+(to_date(to_char(trunc(sysdate),'DD/MM/RRRR
> ')||CALL_DURATION,'DD/MM/RRRR HH24:MI:SS')- trunc(sysdate)) result
> from
> dual;
>
> Making call_duration come in the picture with any value.
>
> Regards,
> Sonty
>
> On Apr 16, 12:37 pm, sonty <[email protected]> wrote:
>
>
>
>
>
> > what about this one:-
>
> > select CALL_START+(to_date(to_char(trunc(sysdate),'DD/MM/RRRR
> > ')||'00:02:15','DD/MM/RRRR HH24:MI:SS')- trunc(sysdate)) result from
> > dual;
>
> > and one thing I would like to highlight it returns date.
>
> > Regards,
> > Sonty
>
> > On Apr 15, 5:18 pm, Iyad Bacdounes <[email protected]> wrote:
>
> > > Thanks it's working,
> > > as you said just math,
>
> > > On 15 April 2010 14:10, Andrej Hopko <[email protected]> wrote:
>
> > > > This is the first shot on problem (the simpliest way, to count this -
> > > > no
> > > > procedure, just math):
>
> > > > SELECT TO_CHAR(CALL_START + SUBSTR(CALL_DURATION,1,2)/24 +
> > > > SUBSTR(CALL_DURATION,4,2)/(24*60) + SUBSTR(CALL_DURATION,7,2)/(24*3600),
> > > > 'DD/MM/YYYY HH24:MI:SS') test
> > > > FROM DUAL;
>
> > > > I think there may be more advanced way to compute this but this works
>
> > > > Andrej Hopko
>
> > > > On 15. 4. 2010 13:50, Iyad Bacdounes wrote:
>
> > > > Have a nice day,
>
> > > > I have the following table
>
> > > > CALL_START CALL_DURATION 15/04/2010 10:05:13 00:02:15 Date Varchar2
> > > > the first column type is date
> > > > the second column type is varchar2
>
> > > > I have an application record every call start time & its duration
>
> > > > I want to create a function or query to get the call end date&time which
> > > > equal
> > > > CALL_START + CALL_DURATION
>
> > > > Best Regards,
> > > > Iyad
>
> > > > --
> > > > Best Regards,
>
> > > > Iyad
> > > > --
> > > > You received this message because you are subscribed to the Google
> > > > Groups "Oracle PL/SQL" group.
> > > > To post to this group, send email to [email protected]
> > > > To unsubscribe from this group, send email to
> > > > [email protected]
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/Oracle-PLSQL?hl=en
>
> > > > --
> > > > You received this message because you are subscribed to the Google
> > > > Groups "Oracle PL/SQL" group.
> > > > To post to this group, send email to [email protected]
> > > > To unsubscribe from this group, send email to
> > > > [email protected]
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/Oracle-PLSQL?hl=en
>
> > > --
> > > Best Regards,
>
> > > Iyad
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Oracle PL/SQL" group.
> > To post to this group, send email to [email protected]
> > To unsubscribe from this group, send email to
> > [email protected]
> > For more options, visit this group
> > athttp://groups.google.com/group/Oracle-PLSQL?hl=en
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group
> athttp://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
