Home   |   Register   |   Members   |   Calendar   |   Get New   |     |  
 


Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > MySQL > Calculating the difference in timestamps

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-23-07, 06:09
Frunkie Frunkie is offline
Gives Bad Advice
  
Join Date: Mar 2007
Location: 010101010110100
Posts: 706
Calculating the difference in timestamps
Hi everyone,

I have a situation that requires me to calculate two fields that both have timestamps in this form "2007-09-27 18:23:03".

Maybe there is a better way to do this, but I thought I would find the difference between the two timestamp fields to come up with a difference in minutes and then average them.

Can someone please help by maybe providing an example or by pointing me in the right direction?
__________________
I and many others around the world are of the strong belief that the universe was created by the Flying Spaghetti Monster. It was He who created all that we see and all that we feel. We feel strongly that the overwhelming scientific evidence pointing towards evolutionary processes is nothing but a coincidence, put in place by Him.
Last edited by Frunkie : 09-23-07 at 06:12.
Reply With Quote
  #2 (permalink)  
Old 09-23-07, 07:46
georgev georgev is offline
SQL Apprentice
  
Join Date: Jan 2007
Location: hiding
Posts: 8,143
__________________
George
You only stop learning when you stop asking questions.
Reply With Quote
  #3 (permalink)  
Old 09-23-07, 08:53
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 13,556
Quote:
Originally Posted by georgev
When in doubt "RTFM"

__________________
r937.com | rudy.ca

pre-order my book Simply SQL from Amazon
Reply With Quote
  #4 (permalink)  
Old 09-23-07, 16:52
Frunkie Frunkie is offline
Gives Bad Advice
  
Join Date: Mar 2007
Location: 010101010110100
Posts: 706
Thanks guys! That was what I needed.
__________________
I and many others around the world are of the strong belief that the universe was created by the Flying Spaghetti Monster. It was He who created all that we see and all that we feel. We feel strongly that the overwhelming scientific evidence pointing towards evolutionary processes is nothing but a coincidence, put in place by Him.
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
Home  |   Register  |   Archive  |   Get New  |   FAQ's

Copyright ©2001-2008 dBforums.com. All Rights Reserved. A division of iNET Interactive.   Advertise on dBForums

Other iNET Interactive Sites: Web Hosting Talk | Swish Talk | Hosting Catalog | Programming Talk | Hot Scripts

 Powered by vBulletin
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.