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