Originally posted by: RPotteti

I am getting date in input with format yyyy-mm-dd I want an output as yyyy-mm-dd 00:00:01.

I tried to append 00:00:01 like this to date

texttodate(yyyy-mm-dd)+texttotime("00:00:01)

Map dosnt give any error but nothing showup in output xml. Datatype for the element in typetree is given as datetime.

Please let me know how can we do this. Thanks for the help.

Originally posted by: RPotteti

Instead of using function on each component we used todatetime function on entire component and it worked.

Here is how we did:

TODATETIME(YYYY-nn-dd+"00:00:01")