1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

TSM 6.1 Timestamp Change

Discussion in 'Scripting' started by chad_small, Nov 29, 2010.

  1. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,197
    Likes Received:
    43
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    So with the update to a DB2 structure the timestamp function has changed so that

    select * from actlog where (current_time-date_time) seconds <= 60 seconds

    Returns an error. So the new timestamp function is the following

    select * from actlog where timestampdiff(8, char(current_timestamp-date_time)) <= 24

    Where the following are the time functions for timestampdiff

    1 - Microseconds
    2 - Seconds
    4 - Minutes
    8 - Hours
    16 - Days ... and so forth

    The information on the changes to the SQL structure in TSM 6.x can be found here under Appendix B.
     
  2.  
  3. nkovacs

    nkovacs New Member

    Joined:
    Oct 20, 2005
    Messages:
    57
    Likes Received:
    2
  4. nkovacs

    nkovacs New Member

    Joined:
    Oct 20, 2005
    Messages:
    57
    Likes Received:
    2

Share This Page