Jump to content

DcVirtual

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

DcVirtual's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. [!--quoteo(post=368611:date=Apr 25 2006, 10:41 PM:name=sanfly)--][div class=\'quotetop\']QUOTE(sanfly @ Apr 25 2006, 10:41 PM) [snapback]368611[/snapback][/div][div class=\'quotemain\'][!--quotec--] Im not quite sure if i understand what you're asking but anyway, to do any maths on a date or time, you need to convert to a unix time stamp with [a href=\"http://php.inspire.net.nz/manual/en/function.mktime.php\" target=\"_blank\"]mktime()[/a] ]. You can then put it back into a normal format using [a href=\"http://php.inspire.net.nz/manual/en/function.date.php\" target=\"_blank\"]date()[/a] [/quote] The field in question already does this, I think. The data is listed in the format I want: Field: TotalBlockTime Data in this field is listed as: 02:15:33 I want to get the total TotalBlockTime of all rows.
  2. Hello All, I have a database which stores a total time value for each entrie: Example Hours, Minutes, Seconds 02:15:33 I want to get the total of every row. I can get the sum but it displays the result as a whole number: Example: 1236894 instead of 143:46:14 Type data: time Null: No Default: 00:00:00 Any help would be great. Thanks in advanced.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.