Am trying to execute
SELECT * FROM a where year(timestamp_column)='2017';
in tmysqlinputcomponent .but am unable to get the result.can any one tell me the solution
FROM `products_urls` where YEAR( modified)='2017'"
this is my query in tmysqlinputcomponent
Solved! Go to Solution.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach