Snaplogic validation and execution result are varying for Snowflake select snap

Hello Experts,
I’m facing issue while executing and during validation of pipeline .
Getting two different result for execution and validation for timestamp column value.

During Validation ,
Result of Mapper

During Execution :-

how to get time value of filed in snowflake?

Validation :-

Mapper :-

just wanted to convert complete date time to string value.