4

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?

Teja Goud Kandula
  • 1,462
  • 13
  • 26

1 Answers1

3

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)

Koushik Roy
  • 6,868
  • 2
  • 12
  • 33
  • 1
    Used something similar to this one. I think what you wrote is Pwc version. IICS is a bit similar to this one. `date:toChar(fn:current-dateTime(), 'MM/DD/YYYY HH:MI:SS')` – Teja Goud Kandula Sep 27 '21 at 14:29