ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Time difference in sql

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Time difference in sql

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

    Hi All ,

    I am trying to calculate the time difference between the two columns in my query . The two columns are of type Decimal and length 6 .

    When i run the query on file the data in columns in presented in below format


    06:11:25 06:11:27
    08:12:12 08:14:10
    09:14:10 10:11:10



    I want to calculate the time difference between two columns .
    can any one help me in calculation the time difference in SQL.

  • #2
    Re: Time difference in sql

    this is old but will still work unlike me!



    jamie
    All my answers were extracted from the "Big Dummy's Guide to the As400"
    and I take no responsibility for any of them.

    www.code400.com

    Comment


    • #3
      Re: Time difference in sql

      SQL Fun with Dates and Times



      To have a good date and time! Don't forget the quotes !

      Comment

      Working...
      X