Thanks for the reply Chris.

For "07/13/2012 1:06:12 AM" --> Web service is returning "2012-07-13T01:06:12.000-04:00" .

I defined my table column as datetime and the program is loading it as...

Lowell, Thanks for the reply.

When I try to offset UTC time to get US time, Is there any way that I can get daylight saving differences also?

Thank you, Grasshopper.

You are right. This sql statement is going from workflow transaction. I couldn't see the code of xamlx file to know where and why it is rolling back....

GSquared, Thanks a lot. I really appreciate your help

It worked.

GSquared,

So do you think that table variables will work in table-valued function?

I cannot put a direct query on the objects since the data I am pulling is related to properties...

GSquared, Thank you so much for the quick reply. I am trying to use use #temp tables in Table-valued function.

After seeing your reply I came to know I cannot...