I am extremely new to FME.
In my data-set, I have a column that displays number of seconds . I need this to be in a time format.
Example: column data displays 181, I need this to read 0:03:01.
Any help would be appreciated.
Best answer by takashi
View original
+16
The DateFormatter transformer should be able to do this.
Source format is %s, Destination format %T
+17
Hi @ryankrawchuk, the DateFormatter could be a quick solution, but it may not work as expected if the timezone of your machine is not set to UTC - Coordinated Universal Time.
If you didn't get your required result from the transformer, try a TclCaller with this Tcl Expression. Assume that an attribute called "_seconds" stores the number of seconds.
clock format [FME_GetAttribute "_seconds"] -format %T -timezone UTC
Both of those worked, though Takashi's answer worked with no further issues.
Thanks!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.