convert input decimal to interval output

Highlighted
Six Stars

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

Highlighted
Six Stars

Re: convert input decimal to interval output

 
Highlighted
Six Stars

Re: convert input decimal to interval output

nobody can help me?

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog