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.
Solved
How do I convert a number of seconds to a time format
Best answer by takashi
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
+17- Contributor
The DateFormatter transformer should be able to do this.
Source format is %s, Destination format %T
+19- Contributor
- Best Answer
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.