Solved

Time difference in seconds

Posted on 2009-04-08
5
484 Views
Last Modified: 2012-05-06
Hello guys,

I am kind of a newbee...

Is there any way to know a time difference in seconds in standard ASP? The time difference will never be more than 100 seconds. I need to know that time difference between 2 times, but the problem I have is when the process runs, for example, from 11:59:25 PM to 00:00:34 AM (for the day change).

Thanks!
0
Comment
Question by:pvg1975
  • 2
  • 2
5 Comments
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 24104636
try:
<%
	
	function getTimeDiff(t1, t2)
		if isDate(t1) = false or isDate(t2) = false then
			getTimeDiff = "-"
		else
			dummyToday = DateSerial(2000,1,1)
			dummyToday2 = DateSerial(2000,1,2)
			
			d1 = CDate(t1)
			d2 = CDate(t2)
			
			if d1 > d2 then
				d1 = dummyToday + d1
				d2 = dummyToday2 + d2
				total = DateDiff("s", d1, dummyToday2) + DateDiff("s", dummyToday2, d2)
			else
				total = DateDiff("s", d1, d2)
			end if
			getTimeDiff = total
		end if
	end function
	
	response.write getTimeDiff("11:59:25 PM", "00:00:34 AM")
	
%>

Open in new window

0
 
LVL 12

Accepted Solution

by:
Dimitris earned 500 total points
ID: 24104657
here you are, you will use datediff

datediff("s","1/1/2009 11:59:25 PM","1/2/2009 00:00:34 AM")

Please keep in mind that my date format is MM/DD/YYYY
0
 

Author Closing Comment

by:pvg1975
ID: 31568400
Thanks for the solution!
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 24104684
huh.. hmmm
0
 
LVL 12

Expert Comment

by:Dimitris
ID: 24104727
sorry ryancys,
I haven't seen your post because i had the question open
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
INNER JOIN ? 8 52
JQuery to parse xml string and get element by id 4 63
Select only the top record in a left join 13 48
Html split(text) Part2 6 20
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question