Ok i tried the following Code where datepart(zeitstempel) = today(); Seem to work but no matches in the database so I tried the following code for a test: where datepart(zeitstempel) = datepart(timestamp '2018-08-08 18:50:07'); but I get this error 33 where datepart(mytimestamp) = datepart(timestamp '2018-08-08 18:50:07');
_____________________
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, CONTAINS,
EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. Not sure what the problem ist.
... View more
