Hi @Thomas_Zhang , Good Day!

Can you give it a try with the below code format and check if it helps you to set the timezone with Z : 

=======================

date_format( to_timestamp(`createdon`, 'yyyy-MM-dd\'T\'HH:mm:ss.SSSSSSSX'), 'yyyy-MM-dd\'T\'HH:mm:ss.SSSSSSSX' )

=======================

Please let me know if this helps and leave a like if this information is useful, followups are appreciated.
Kudos
Ayushi