Planned dates internal format?

[matthias_brisseau2]

Hello,

We noticed something strange in CGPL tables. When looking at planned dates (start or finish), their is a gap of one day between what we see in the portal and what is recorded in the database.

Let's say the planned start date for a task is set to 15.09.2008 in the portal, the timestamp value in CGPL_TASK table is 20080914220000 ! What's more, when I convert this value to output value (FM CONVERSION_EXIT_TSTPS_OUTPUT), I get 14.09.2008 22:00:00 ! However, the value in the portal is still 15.09.2008

Does anyone know how these dates are managed?

Basically we need to retrieve them in a custom program, but we are currently not able to retrieve the exact date due to this "1 day" gap.

Thank you.

Matthias

[matthias_brisseau2]

Solve by our own.

We can use the following conversion code:

CONVERT TIME STAMP es_task_int-planstart TIME ZONE cl_cgpl_scheduling=>m_tzone

INTO DATE es_task_ext-scheduled_start.

Matthias