Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

SET_DATE_PART - Change date or month or year part in DateTime in Informatica

  1. Forget Code
  2. Informatica
  3. SET_DATE_PART - Change date or month or year part in DateTime
Syntax
SET_DATE_PART( date, format, value )

Example : Change the month to July, irrespective of input month.
SET_DATE_PART( DATE_PROMISED, 'MON', 7 )

DATE_PROMISEDRETURN VALUE
Jan 1 2012 12:15:56AMJul 1 2012 12:15:56AM