Incremental Load Date format issue

[brijesh1991]

I had incremental date: Last Update Date in M/DD/YYYY hh:mm:ss TT format.

Example: 8/11/2009 10:37:00 AM

While taking incremental Load;

Load * from table where  [Last Update Date] >= $(vThisExeTime) and [Last Update Date] <=$(vLastExeTime)

where vThisExeTime= chr(39) & Date(now(), 'M/DD/YYYY hh:mm:ss TT') & chr(39)

and the same is storing at end of the entire script into vLastExeTime.

But I am getting error: Attached image

[tresB]

Try putting single quotes around variable expansion, like: ' $(vThisExeTime)'

Edit: you might have to redefine your variable excluding chr(39)

[nilesh_gangurde]

See this link, this will help you.

Incremental Load Help??

-Nilesh

[brijesh1991]

Thanks TRESESCO for your idea... but unfortunately not working!

[rwunderlich · Accepted solution]

I haven't worked with Sybase, but from the doc it appears timestamps should be of the ISO 8601 standard format  of YYYY-MM-DD hh:mm:ss. So try presenting your SQL WHERE arguments in that format.

-Rob

[tresB]

Possibly a format mismatch. Please be doubly sure of it; check little things like, if any space difference, or so.

[brijesh1991]

Hi Rob,

you are wonderful, even if you haven't worked on sybase, your idea worked. . .!

Thanks brother!!! Thanks!