TRUNC - Truncate Day or month or year part in DateTime in Informatica

The TRUNC function truncates dates to a specific year, month, day, hour, or minute.

TRUNC( date [, format ] )


Example : Truncate Year Part in Informatica
TRUNC( DATE_SHIPPED, 'YY' )
DATE_SHIPPED             RETURN VALUE
Feb 15 2012 2:10:30AM         Jan 1 2012 12:00:00AM