Close popover
Narendra Devarapalli (NARENDRAD)
Anthem Inc
Sr Developer
Anthem Inc
NARENDRAD Member since 2012 7 posts
Anthem Inc
Posted: July 17, 2017
Last activity: August 14, 2017

One hour is adding to actual date time during GMT format conversion

Hi All,

I am getting input values from DB with below SQL query using RDB list from PEGA application.

convert(varchar(64), min(pxCreateDateTime), 112) + 'T' +
replace(convert(varchar(64), min(pxCreateDateTime), 108), ':', '') + '.000' as StartTime,
convert(varchar(64), max(pxUpdateDateTime), 112) + 'T' +
replace(convert(varchar(64), max(pxUpdateDateTime), 108), ':', '') + '.000' as EndTime
from dbo.pc_work
where pxCreateDateTime > convert(char(10), getdate(), 101)
Results are :
ProcsStartTime =20170717T000108.000 & ProcsEndTime=20170717T010405.000
from the above example start time is 12:01:08 & end time is 01:04:05
Now I am calling the same RDB list in my activity and i am passing the results to startDate(DateTime) and EndDate(DateTime) parameters. Obviously pega converting them to GMT and the values for parameters are as below
EndAsString20170717T010405.000 (Came from DB as 01:04:05AM EST)
EndDate20170717T060405.000 GMT (After Pega converting to GMT it becomes02:04:05 EST )
StartAsSting20170717T000108.000 (Came from DB as 12:01:08 AM EST)
StartDate20170717T050108.000 GMT (After Pega converting to GMT it becomes01:01:08 EST)
Can anyone let us know what would be the reason why an extra hour is being added in 7.X? in 5.4 version same logic works fine but in 7.X it is not working.
In my operator ID time zone as America/New_york
Enterprise Application Development Dev/Designer Studio Data Integration Java and Activities
Moderation Team has archived post