|
 |
asp_web_howto thread: Getting total minutes
Message #1 by "Andy" <andy@t...> on Tue, 25 Mar 2003 04:47:57 +0800
|
|
Hello,
I have field in one of my table with the data type datetime ( MS SQL
server ).
I am trying to calculate the total minutes /hours / days since the last
action taken by subtracting it with the current time.
How can I achieve this in ASP?Thanks
Regards,
Andy
Message #2 by Mark Eckeard <meckeard2000@y...> on Mon, 24 Mar 2003 13:04:48 -0800 (PST)
|
|
Andy,
Look into the datediff function:
http://www.devguru.com/Technologies/vbscript/quickref/datediff.html
Mark.
--- Andy <andy@t...> wrote:
> Hello,
>
> I have field in one of my table with the data type
> datetime ( MS SQL
> server ).
>
> I am trying to calculate the total minutes /hours /
> days since the last
> action taken by subtracting it with the current
> time.
>
> How can I achieve this in ASP?Thanks
>
> Regards,
>
>
> Andy
>
>
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Message #3 by "Andy" <andy@t...> on Tue, 25 Mar 2003 05:08:55 +0800
|
|
Hello Mark,
Thanks for the link.
Regards,
Andy
----- Original Message -----
From: "Mark Eckeard" <meckeard2000@y...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Tuesday, March 25, 2003 5:04 AM
Subject: [asp_web_howto] Re: Getting total minutes
> Andy,
>
> Look into the datediff function:
>
> http://www.devguru.com/Technologies/vbscript/quickref/datediff.html
>
> Mark.
> --- Andy <andy@t...> wrote:
> > Hello,
> >
> > I have field in one of my table with the data type
> > datetime ( MS SQL
> > server ).
> >
> > I am trying to calculate the total minutes /hours /
> > days since the last
> > action taken by subtracting it with the current
> > time.
> >
> > How can I achieve this in ASP?Thanks
> >
> > Regards,
> >
> >
> > Andy
> >
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
> http://platinum.yahoo.com
>
>
>
|
|
 |