tMSSqlInput component, invalid escape sequence

[Anonymous]

Hello, 

I am currently starting with Talend and I am facing a problem.

I use DBVisualizer as database tool and I have no error on it. Then I try the same query into Talend. When I use the 'Guess Schema'  button, I face the following error :

 Invalid escape sequence (valid ones are \b \t \n \f \\" \' \\)

From what I understand, the problem is in the syntax of my query. I should escape "\" with "\\". Then, the point I don't understand is that I have no "\" into my query and still this error. 

You will find in attachment the query I use.

If someone can explain to me the origin of the problem, I would be grateful.

Thank you in advance, 

best regards. 

[Anonymous]

I removed the extra quotation mark at the end of the first SELECT, but it is still not working

[cterenzi]

The first line still looks a little off. The '1970-01-01' is not part of the DATEADD argument list.

[Anonymous]

You're right. Thank you.

I corrected it but the problem still persist.