dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: Algorithms
Expertise: Beginner
Mar 3, 1997

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Calculating time intervals

Question:
How does one calculate time differences. I know there's a function to calculate date differences.I am coding a database program which includes calculating the difference between a start time and a finish time.

Answer:
Even though it is called the DateDiff function, it can be used to calculate up to second differences between two date/time values. All you have to do is change the first argument, which is the interval argument, to one of the following codes:

  • yyyy - Year
  • q - Quarter
  • m - Month
  • y - Day of year
  • d - Day
  • w - Weekday
  • ww - Week
  • h - Hour
  • n - Minute
  • s - Second
You then add the remaining arguments of the DateDiff function and it will return the difference in the unit specified by the interval argument. Do a search for DateDiff in your Visual Basic help file for more details on how to use this function.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date