DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: date help

Threaded View

  1. 07-01-2008, 06:46 AM #4
    ali560045
    ali560045 is offline Junior Member
    Join Date
    Jun 2008
    Posts
    38
    i got the below sql

    select ( max(time_value) - min(time_value))
    DAY(9) TO SECOND FROM std_detail;

    output: +142 09:35:44.000000


    ----------------------------------------------------

    min(time_value)---------> 27/06/2008 17:55:06

    max(time_value)---------> 17/11/2008 03:30:50

    result ( max(time_value) - min(time_value)----> 142 09:35:44.000000
    ------------------------------------------------------------------------

    got the answer now. thanks ever1 for ur help........
    Last edited by ali560045; 07-01-2008 at 06:55 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width