Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Gabri11
Contributor
Contributor

convert input decimal to interval output

Hi everyone, I need to import an interval type field into a postgresql database. The origin is in decimal format.

 

An example:
source = 1.5 (one and a half hours)
output = 01:30:00 (1 hour : 30 minutes : 00 seconds)

How can I do using tmap? What kind of data should I set?
Thank you

Labels (2)
1 Reply
Gabri11
Contributor
Contributor
Author

nobody can help me?