Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Filter value

how to use - convert_timezone('UTC',CURRENT_TIMESTAMP) in filter value

2 Community Answers

Matillion Agent  

Ian Funnell —

Hi Hanumanth,

You can’t use this syntax directly in a Filter component. Instead, the way to do it is to use a Calculator to add the new field with the converted timestamp, and afterwards filter on the new field.

Best regards,
Ian


Hanumanth Andela —

Thanks Ian , I have replaced the table input and filter component with single SQL component as input :)

Post Your Community Answer

To add an answer please login