Pega Report filter for datetime field is missing few results which have millisecond variation on there updatedatetime when we pass GMT time

[RameshSangili]

@RashmithaM

we are trying to pull data based on below filter criteria but pega internally is adding milliseconds when generating the query for this. We lost some data where pxupdatetime has few milliseconds difference on them.

Eg: We pass Param.UpdateDate as 20260315T131032.676 GMT but pega when generating the query, it is passing as 2026-03-15 131033.675 it is adding an second automatically which is not pulling records within this 1 sec duration variation. Can someone help us in determining why pega is adding an extra second when we pass the GMT time or how can we make changes to pull the records with in a second difference as well.

Is this consistent? I never seen this issue? Which version? how did we conclude that it add extra 1 second? What happens if we hardcode for testing? Is the query gets the correct date?