lundi 26 janvier 2015

DB2 LUW Timestamp differences in versions


Im new to DB2, my back ground is in MS SQL server 2000 thru 2012.


Have a developer using Local DB DB2 LUW v9.7.500.4299 FIXPACK_NUM = 5


She is selecting some data from a table where the field is a Timestamp data type.


She can select it and get a return using the following WHERE CRTD_DT_TM = '2014-11-19 18:00:00'


But if she does the same thing in the Prod version: DB2 LUW v.9.7.0.6 FIXPACK_NUM=6 she doesn't get anything in return.

She actually has to add the milliseconds to the query:


Where CRTD_DT_TM = '2015-01-13 04:32:13.080000'


Is this an issue between versions? If so Is there a FIX pack that has addressed this?


Thanks in advanced!





Aucun commentaire:

Enregistrer un commentaire