List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:February 21 2000 3:59pm
Subject:Re: DATE arithmatic
View as plain text  
>>>>> "K" == KevinWaterson  <kevin@stripped> writes:

K> of months between two dates.
K> I have a date format like 2000-02-20 06:55:06 and 2000-02-20 08:27:31

K> How do I best find how many seconds have elaped here?

You convert the dates to number of seconds since a pre-determined
time, then subtract.

This is just a matter of converting your given value into the units of
interest.
Thread
mysql_value(res,i,j) wanted :-)(Alexander Barkov)28 Jan
  • Re: mysql_value(res,i,j) wanted :-)sinisa28 Jan
  • ANSWER: mysql_value(res,i,j) wanted :-)Michael Widenius29 Jan
    • Re: ANSWER: mysql_value(res,i,j) wanted :-)Benjamin Pflugmann30 Jan
      • Re: ANSWER: mysql_value(res,i,j) wanted :-)Michael Widenius30 Jan
        • Re: ANSWER: mysql_value(res,i,j) wanted :-)Benjamin Pflugmann30 Jan
          • Re: ANSWER: mysql_value(res,i,j) wanted :-)Michael Widenius5 Feb
  • dump errorkevin7 Feb
    • Re: dump errorsinisa7 Feb
  • DATE arithmaticKevinWaterson21 Feb
    • Re: DATE arithmaticsinisa21 Feb
    • Re: DATE arithmaticVivek Khera21 Feb
  • triggers ?KevinWaterson12 Mar
    • Re: triggers ?Jonathan Stimmel12 Mar