Subtract one datetime from another

[Simon Gare]

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]]

Take a look at DateDiff()

 

[Kyle Peterson]

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