Solved

diff between time and date?

Posted on 2001-07-17
15
270 Views
Last Modified: 2008-03-17
Can i find the difference between two time variables generated by now(). What is the easiest way to do that?
0
Comment
Question by:rav_chow
  • 6
  • 4
  • 3
  • +2
15 Comments
 
LVL 1

Expert Comment

by:erezsh
ID: 6290633
Use DateDiff() function:

Description:
  Returns the number of intervals between two dates.
Syntax:
  DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]])

  Erez Sh.
0
 
LVL 1

Expert Comment

by:erezsh
ID: 6290649
interval:
Required. String expression that is the interval you want to use to calculate the differences between date1 and date2.

date1, date2: Required. Date expressions. Two dates you want to use in the calculation.

firstdayofweek: Optional. Constant that specifies the day of the week. If not specified, Sunday is assumed. See Settings section for values.

firstweekofyear: Optional. Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs. See Settings section for values.

The interval argument can have the following values:
Setting - Description
yyyy - Year
q - Quarter
m - Month
y - Day of year
d - Day
w - Weekday
ww - Week of year
h - Hour
n - Minute
s - Second


0
 
LVL 5

Expert Comment

by:dredge
ID: 6290654
i agree with erezsh.

Interval = the time interval to find (month, week, second, etc)

date1= a date (your first Now )
date2= another date (your second Now )

and the other two values are optional and shouldn't be changed unless you need to know specific day/year stuff.
0
 

Author Comment

by:rav_chow
ID: 6290694
friends, I asked for time.. ie. hour ,min ..
0
 

Expert Comment

by:HabBoy
ID: 6290772
You asked for date and time and erezsh kindly gave you both.
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6290797
Now
 
The Now function returns the date and time as determined by your computer.
 
Code:
<% =Now %>
 
Output:
07/17/2001 10:36:12

If you want to get the diff on time, you will need to create seperate functions to retrieve each value;

dh = DateDiff(h, Now(), (Now()-4))

Response.Write dh
0
 

Author Comment

by:rav_chow
ID: 6290882
Microsoft VBScript runtime error '800a0005'

Invalid procedure call or argument: 'DateDiff'

this is the error is get when i try datediff
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 1

Accepted Solution

by:
erezsh earned 100 total points
ID: 6290883
To get the differeces between two dates (and times) in minutes, for example, use:
MinDiff = DateDiff("n", date1, date2)

Please read all of my answer fully.

btw 10x for the support ;)
  Erez Sh.

 
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6290894
Maybe you should go to the DevGuru web site and read up on the function DateDiff().
0
 

Author Comment

by:rav_chow
ID: 6290897
Microsoft VBScript runtime error '800a0005'

Invalid procedure call or argument: 'DateDiff'

this is the error is get when i try datediff
0
 
LVL 1

Expert Comment

by:erezsh
ID: 6290921
Give me the entire code that you are using so I can tell you what's wrong.
0
 
LVL 1

Expert Comment

by:erezsh
ID: 6290941
Here is a full code that tell you how long ago was the 24/6/2001 in says:

<HTML>
<BODY>
<%
date1= now
date2= #24/6/2001#
DayDiff = DateDiff("d",date1,date2)
response.write DayDiff
%>
</BODY>
</HTML>

It works. If it doesn't work for you, then your server has a problem.

  Erez Sh.
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6290942
You do have IIS installed don't you?
0
 
LVL 1

Expert Comment

by:erezsh
ID: 6290951
(in days)
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6290966
This tells you exactly in hours, the difference betweeen Now annd 4 days ago;

<%
dh = DateDiff("h", Now(), (Now()-4))

Response.Write dh
%>
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

760 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now