Introducing Radical.sh

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

Round - Rounds one part of the date in Informatica

  1. Forget Code
  2. Informatica
  3. Round - Rounds one part of the date
Syntax 
ROUND( date [, format ] )


Example : Round the month part of the date in Informatica 
ROUND( DATE_SHIPPED, 'MON' )
DATE_SHIPPED         RETURN VALUE
Jan 15 2011 4:10:30AM     Jan 1 2011 12:00:00AM


Sample function can be applied to Year, date and time part by changing the format string.