How to get Time in Automation Template

[Nani]

In my automation template I need time, but I am having column type as Date Time. What I need to place to get only time

[Suvrutt_Gurjar · Accepted solution]

Please try TIME([DateTime Column Name])

or alternatively

TEXT([DateTime Column Name],"HH:MM:SS")