Wrong UTCDateTime Value is fetched

Hi All,

Let me take an example.

There is one UTCDateTime field in EmplTable “CreatedDateTime”.

The actual value of that field is “20/05/2012 11:30:00 am”.

When i select that value through job code,I am getting that valus as “20/05/2012 6:30:00 pm”

I want to fetch the actual value as it is in table.So Please help me to solve this problem.

Actual Value in Table:“20/05/2012 11:30:00 am”

Fetched Value From Table: “20/05/2012 6:30:00 pm”

It is fetched the value adding 7 to theactual datetime value.

I need the actual table value “20/05/2012 11:30:00 am”.

Please help me.

Thanks & Regards,

Britto John Baskar.A

How are you fetching the value? Please can you post your code?

Hi Harish,

I fetched using select query

select EmplTable where EmplTable .EmplId==“1000”;

info(strfmt("%1",EmplTable .CreatedDateTime));

Thanks…