topic Re: how to execute year(date)mysql query in tmysqlinput component in Talend Studio

how to execute year(date)mysql query in tmysqlinput component

bhagyarekha — Thu, 04 May 2017 12:26:02 GMT

HI All

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

"SELECT
`products_urls`.`id`,
`products_urls`.`modified`
FROM `products_urls` where YEAR( modified)='2017'"

this is my query in tmysqlinputcomponent

Thanks

Rekha

Anonymous — Thu, 04 May 2017 12:40:37 GMT

You mean you get no rows from the input component?

A screenshot would be very helpful.

bhagyarekha — Thu, 04 May 2017 12:46:37 GMT

ya thank you i got solution i missed `modified` for modified .

now it is working fine

Anonymous — Thu, 04 May 2017 12:55:32 GMT

oh alright cool.