Search For
Flagging a Snippet, takes the snippet to Moderator Attention;


0
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
Vote! You feel this code is working like charm ? Go a head Login and Press up arrow.
Didn't work ?, press down arrow and let us know the error in comments

Comments