I'm using Access database and I want to write an command as bellow in LLBL prefetch path Can anyone help me to translate

SELECT * FROM table1 WHERE FORMAT(lastModified, 'yyyy-mm-yy hh:mm:ss') >= #FORMAT(@lastModified, 'yyyy-mm-yy hh:mm:ss')#

I'm using Access database and I want to write an command as bellow in LLBL prefetch path Can anyone help me to translate

SELECT * FROM table1 WHERE FORMAT(lastModified, 'yyyy-mm-yy hh:mm:ss') >= #FORMAT(@lastModified, 'yyyy-mm-yy hh:mm:ss')#

PrefetchPaths has noting to do with the above query, or am I missing something?

You should use DBFuctionCall to implement the Format() function.

I'm not familier with the '#' character, would you please explain the left hand side of the equality.