|
 |
asptoday_discuss thread: Subtract two times
Message #1 by Afif <aviv93@y...> on Mon, 18 Feb 2002 18:01:18 +0700
|
|
How to subtract two times ?. I still confused with dateadd or datediff
function. Can I use their function ? Sorry I'm new comer in ASP.
Any appreciate if any one call help me. Thank you.
-Afif-
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message #2 by "ASIM ABBASI" <asim_electro@h...> on Mon, 18 Feb 2002 11:13:06 -0500
|
|
Dear Afif,
There is nothing to be confused. Let me give u real world example.
datediff:-
If u want to know whats the difference in dates between your age and your
father's age; use the datediff function.
dateadd:-
On the same lines, if u want to add two dates, use the dateadd function.
Moreover, keep this in mind when we talk about "time" we are actually
referring to time-axis compeltely defined by DD/MM/YYYY HH:MM:SS. So by
adding/subtracting two times/dates means u are adding/subtracting two
quantities on axis, it may be X-axis or Y-axis or Time-axis.
Regards,
Asim Abbasi
Chief Technologist
Integrated Product Development Solutions, Inc.
www.geocities.com/eingenuity
----- Original Message -----
From: "Afif" <aviv93@y...>
To: "ASPToday Discuss" <asptoday_discuss@p...>
Sent: Monday, February 18, 2002 6:01 AM
Subject: [asptoday_discuss] Subtract two times
> How to subtract two times ?. I still confused with dateadd or datediff
> function. Can I use their function ? Sorry I'm new comer in ASP.
>
> Any appreciate if any one call help me. Thank you.
>
> -Afif-
>
>
>
> _________________________________________________________
>
> Do You Yahoo!?
>
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>
>
>
Message #3 by Afif <aviv93@y...> on Tue, 19 Feb 2002 09:28:43 +0700
|
|
Thank you Asim,
Can you give me a little script. For example I have two times like this.
8:45:00 and 7:35:00. How difference minutes between their ? . Both of
Times I take from formatdatetime(rs("xx"),4).
-afif-
At 11:13 AM 2/18/2002 -0500, you wrote:
>Dear Afif,
>
>There is nothing to be confused. Let me give u real world example.
>
>datediff:-
>
>If u want to know whats the difference in dates between your age and your
>father's age; use the datediff function.
>
>dateadd:-
>
>On the same lines, if u want to add two dates, use the dateadd function.
>
>Moreover, keep this in mind when we talk about "time" we are actually
>referring to time-axis compeltely defined by DD/MM/YYYY HH:MM:SS. So by
>adding/subtracting two times/dates means u are adding/subtracting two
>quantities on axis, it may be X-axis or Y-axis or Time-axis.
>
>Regards,
>
>Asim Abbasi
>Chief Technologist
>Integrated Product Development Solutions, Inc.
>www.geocities.com/eingenuity
>
>
>
>
>----- Original Message -----
>From: "Afif" <aviv93@y...>
>To: "ASPToday Discuss" <asptoday_discuss@p...>
>Sent: Monday, February 18, 2002 6:01 AM
>Subject: [asptoday_discuss] Subtract two times
>
>
> > How to subtract two times ?. I still confused with dateadd or datediff
> > function. Can I use their function ? Sorry I'm new comer in ASP.
> >
> > Any appreciate if any one call help me. Thank you.
> >
> > -Afif-
> >
> >
> >
> > _________________________________________________________
> >
> > Do You Yahoo!?
> >
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
> >
> >
> >
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
|
|
|
View Cart
