Six Stars

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

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

 

  • Data Integration
Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

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

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

now it is working fine

3 REPLIES
Six Stars

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

You mean you get no rows from the input component? 

A screenshot would be very helpful.

 

Six Stars

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

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

now it is working fine

Six Stars

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

oh alright cool.