Pass a specific time with today's date as a value to the input field in Informatica Cloud

user_9087250 0
Viewed 377

There is a mapping task which has a input field, the value provided to the field should be today's date and time is 18:00:00.000000000. What is the formula to build this one?

Suppose the current month is 9, it should be passed as 09. Same with the date, if the date is a single digit, 0 should be appended in the last.

The expected output for today is : 09/24/2021 18:00:00.000000000

The formula to build this value?

informatica-cloud informatica parameter-passing
1 Answers

can you use this ?

to_char(sysdate,'MM/DD/YYYY') || '18:00:00.000000000'

Pls note this will produce a string.
If you want a datetime, pls convert this to datetime using to_date(above_st, format)

user_64305230
Related