GET_DATE_PART - Extract days or month or year date part from the date in Informatica

GET_DATE_PART( date, format )

Example: The following expressions return the day for each date in the input port
 GET_DATE_PART ( DATE_SHIPPED, 'D' )

DATE_SHIPPEDRETURN VALUE
Mar 13 1997 12:00:00AM13
June 3 1997 11:30:44PM3
NULLNULL

Example 2: Get month from a date in informatica
 GET_DATE_PART ( DATE_SHIPPED, 'MM' )

DATE_SHIPPEDRETURN VALUE
Mar 13 1997 12:00:00AM3
June 3 1997 11:30:44PM6
NULLNULL

To know about all the formats in Get Date Part Get Date Part - Date Formats