Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP General (http://www.velocityreviews.com/forums/f65-asp-general.html)
-   -   Subtract one datetime from another (http://www.velocityreviews.com/forums/t801497-subtract-one-datetime-from-another.html)

Simon Gare 06-19-2006 07:04 PM

Subtract one datetime from another
 
Hi all,

need to subtract one date from another to show how long a user was logger in
for.

i.e.

<%=(rsDriverLogin.Fields.Item("OFF_DATE").Value) %> minus
<%=(rsDriverLogin.Fields.Item("ON_DATE").Value)% >

The values in the sql OFF_DATE and ON_DATE fields are stored as

13/06/2006 19:01:28

Can either be done on the ASP page or in the db itself, doesn't matter
which.

Regards
Simon



Aaron Bertrand [SQL Server MVP] 06-19-2006 07:09 PM

Re: Subtract one datetime from another
 
Take a look at DateDiff()




"Simon Gare" <sg@simongare.com> wrote in message
news:%23K8xiM9kGHA.2304@TK2MSFTNGP02.phx.gbl...
> Hi all,
>
> need to subtract one date from another to show how long a user was logger
> in
> for.
>
> i.e.
>
> <%=(rsDriverLogin.Fields.Item("OFF_DATE").Value) %> minus
> <%=(rsDriverLogin.Fields.Item("ON_DATE").Value)% >
>
> The values in the sql OFF_DATE and ON_DATE fields are stored as
>
> 13/06/2006 19:01:28
>
> Can either be done on the ASP page or in the db itself, doesn't matter
> which.
>
> Regards
> Simon
>
>




Kyle Peterson 06-19-2006 11:53 PM

Re: Subtract one datetime from another
 

http://www.powerasp.com/content/new/...ference-19.htm

"Simon Gare" <sg@simongare.com> wrote in message
news:%23K8xiM9kGHA.2304@TK2MSFTNGP02.phx.gbl...
> Hi all,
>
> need to subtract one date from another to show how long a user was logger
> in
> for.
>
> i.e.
>
> <%=(rsDriverLogin.Fields.Item("OFF_DATE").Value) %> minus
> <%=(rsDriverLogin.Fields.Item("ON_DATE").Value)% >
>
> The values in the sql OFF_DATE and ON_DATE fields are stored as
>
> 13/06/2006 19:01:28
>
> Can either be done on the ASP page or in the db itself, doesn't matter
> which.
>
> Regards
> Simon
>
>





All times are GMT. The time now is 09:58 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.