TSM 6.1 Timestamp Change

[chad_small]

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.

 

[nkovacs]

There were a good number of changes to the SQL engine, namely because DB2 handles most of the SQL now instead of the legacy database engine. More changes to the SQL syntax are documented in the link below.

http://publib.boulder.ibm.com/infoc...tsm.srv.upgrd.doc/r_srv_upgrd_cmd_select.html

 

[nkovacs]

Also I recently was looking up how to do some date/time manipulation and found the following link very helpful. It gives a bunch of date/time calculation examples.

http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html