TIMESTR
Returns the time value of a DateTime.
Syntax
string TIMESTR(DateTime? value)
string TIMESTR(DateTime? value, string format)
Example
TIMESTR(DATETIME("02:30:22"))
will return '02:03:22'.
or
TIMESTR(DATETIME("02:30:22"),"H:mm:ss")
Will return '2:30:22'. The above format will remove any unnecessary noughts at the start of the time however it will not remove digits from the hour if there are two digits i.e. TIMESTR(DATETIME("12:30:22"), "H:mm:ss")
will return '12:30:22'.