Error making a selection in Teradata with R

Question

When I try to import teradata data with a where in the sql statement I get the following error

clients<-dbGetQuery(con, "SELECT * from clients where year(cl_dataentrada) = 2018")

Error in new_result(connection@ptr, statement) : nanodbc/nanodbc.cpp:1344: 42000: [Teradata][ODBC Teradata Driver]Teradata DatabaseSyntax error: expected something between the 'where' keyword and the 'year' keyword.

clients<-data.frame(clients)

I've also tried:

clients<- dbSendQuery(con, "SELECT * from clients where year(cl_dataentrada) = 2018")

Error in new_result(connection@ptr, statement) : nanodbc/nanodbc.cpp:1344: 42000: [Teradata][ODBC Teradata Driver]Teradata DatabaseSyntax error: expected something between the 'where' keyword and the 'year' keyword.

Also in a sql chunk :

SELECT * from clients where year(cl_dataentrada) = 2018

Error in new_result(connection@ptr, statement) : nanodbc/nanodbc.cpp:1344: 42000: [Teradata][ODBC Teradata Driver]Teradata DatabaseSyntax error: expected something between the 'where' keyword and the 'year' keyword. Failed to execute SQL chunk

Answer 1

As Shiva Prakash suggested this finally works:

clients<-dbGetQuery(con, "SELECT * from clients where extract(year from cl_dataentrada)=2018")

It was an error because the function year is an odbc function not Teradata. Thank you.