Round - Rounds one part of the date in Informatica

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.