Incremental Loading Timestamp Error

[#1]

Hi

I have tried formatting the timestamp in all the ways that are referred in the community. In simple words, I am tired of searching answer for my problem.

I want a query string which needs to look for the modified_date field for values greater than 2/8/2013 3:32:19 PM which is stored in $(LastExecTime) .

ANy help on this ??

[sivarajs]

Select * from table where modified_date>'$(LastExecTime)';

[SunilChauhan]

try to put it in sigle quotes

modified_date>'$(LastExecTime)'

hope this helps