how to compare time row by row

Discussion in 'Programming' started by baktha.thalapathy, May 17, 2010.

  1. #1
    i have ouput like this
    
    
    2010-05-14 16:47:04.0
    2010-05-14 16:48:04.0
    2010-05-14 16:49:04.0
    2010-05-14 18:50:50.0
    2010-05-14 18:51:50.0
    
    Code (markup):
    i am going to get the minutes difference between the timestamp,

    how do i get the difference row by row

    please help me any body having idea
     
    baktha.thalapathy, May 17, 2010 IP
  2. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Hi,
    if this output comes from DB, just use TIMESTAMPDIFF function.
    Regards :)
     
    koko5, May 17, 2010 IP