[dba-SQLServer] [Cross-Posted to VB and SQL] elapsed time in ASP.Net

Hi Jeff

I'm not into VB.NET but in C# you have a TimeSpan data type which you get by
subtracting in-time from out-time. Then you can format this as you like to,
say, h:mm.

/gustav


-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Jeff B
Sendt: 30. august 2012 21:48
Til: dba-VB; Dba-SQL
Emne: [dba-SQLServer] [Cross-Posted to VB and SQL] elapsed time in ASP.Net

Hello ALL!
 
I am trying to determine the elapsed time on an ASP.net site.  I am using
VB.net for coding and SQL Server 2008 Time (7) data type for the time
values.  I am using a button to record a time in and a second button to
record time out.  What I would like to do is create a third button that
would allow the users to click the button and see the elapsed time.  I also
want to store this value as a Time (7) data type.  
 
I have found numerous examples using datediff, but none of them seem to be
working for me.  Has anybody here tried this?  Can someone help point me in
the right direction?
 
Thanks in Advance for ANY help!
 
Jeff Barrows
MCP, MCAD, MCSD
 
Outbak Technologies, LLC
Racine, WI
 <mailto:jeff at outbaktech.com> jeff.developer at gmail.com