Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2011
    Posts
    1

    Unanswered: minutes issue in db2

    Hi Friends

    I am new to db2 and currently stuck with an issue regarding the usage of minutes in db2 for which i need your help. below are the details.

    I have a 2 timestamp fields and i am subtracting both from each other like
    (X.SEND_TS2 - X.SEND_TS1).
    what i have to do now is to find if the result of this comparison is less than 15 minutes.
    how do i do that in db2.
    any suggestions would be of great help.

    Thanks
    vikeng

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    all these people that are new to db2, why don't they ever read the doc -- you can not learn db2 by reading/posting to the forum..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    It may be better for beginners to read this article before go to manuals.

    DB2 Basics: Fun with Dates and Times
    Introduction

    This short article is intended for those who are new to DB2 UDB and wish to
    understand how to manipulate dates and times. Most people who have
    worked with other databases are pleasantly surprised by how easy it is in DB2 UDB

  5. #5
    Join Date
    Jun 2007
    Location
    germany
    Posts
    155

    Talking

    Quote Originally Posted by przytula_guy
    all these people that are new to db2, why don't they ever read the doc -- you can not learn db2 by reading/posting to the forum..
    you are assuming that they want to learn.
    i just assume they want someone else to do their work for them.
    Dick Brenholtz, Ami in Deutschland

Posting Permissions

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