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
20170717T010405.000 (Came from DB as 01:04:05AM EST)
20170717T060405.000 GMT (After Pega converting to GMT it becomes02:04:05 EST )
20170717T000108.000 (Came from DB as 12:01:08 AM EST)
20170717T050108.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.
I am not using any function. simple activity I am getting results like start date as 20170718T000116.000 , End Date as 20170718T010817.000 , in the 2nd step I am setting these properties in property set to dateTime parameters like param.StartDate = "20170718T000116.000" and Param.Enddate="20170718T010817.000 " In the tracer I could see as below which is different vaule.
as per input value coming from database Start date should be "20170718T040116.000 GMT" but it is adding on more hour & giving result as "20170718T050116.000 GMT"
I have also tried using the below Java code to see how EST to GMT conversion happening it is also giving "20170718T050116.000 GMT"
java.text.DateFormat gmtFormat = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");