is it possible to get Time differenin sql server?

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server ASP
is it possible to get Time differenin sql server?

SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

August 6th, 2004, 01:39 AM

blueguy

blueguy is offline

Authorized User

Join Date: Jul 2004

Posts: 13

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via MSN to blueguy

Default

is it possible to get Time differenin sql server?

Table1 Table2 TimeDifference

08.28.2004 09:10:14 08.25.2004 09:10:14 72 hour 0 minute

Old

August 6th, 2004, 11:16 PM

happygv

happygv is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 2,480

Thanks: 0

Thanked 1 Time in 1 Post

Default

How about this?

Code:

select cast(datediff(mi,'08.25.2004 09:10:14', '08.28.2004 09:10:14')/60.00 as decimal(6,2))

Cheers!

_________________________
- Vijay G
Strive for Perfection

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Microsoft][ODBC SQL Server Driver] TIME OUT ERROR	rtr1900	ASP.NET 2.0 Basics	1	November 12th, 2008 09:36 AM
time in sql server is not real time	hertendreef	SQL Server 2005	6	April 19th, 2007 07:07 AM
Run-time error '20599'; Cannot open SQL Server	manishashar888	Pro VB Databases	7	March 20th, 2007 07:04 AM
run-time error '20599' : cannot find sql server	juicyfruit	SQL Server 2000	1	February 16th, 2006 06:25 AM
DLLs on server pulling server time or client?	mussitsch	Classic ASP Professional	1	March 1st, 2005 05:38 AM