You can use full pushdown to push the SYSDATE variable to the Amazon Redshift database in an expression transformation.
When you use full pushdown to push the SYSDATE variable, it corresponds to the date/time data type of the Amazon Redshift cluster, while for mappings without pushdown optimization the SYSDATE variable corresponds to the date/time data type of the agent.