Check date format in informatica. Example Values of source column: 22-AUG-2010 --> V...
Nude Celebs | Greek
Check date format in informatica. Example Values of source column: 22-AUG-2010 --> Valid date/format as per business rule 22 AUG 2010 --> InValid date/format as per business rule 22/AUG/201 ---> Invalid date/format as per business rule I have used is_date function in expression as below :i is_date (input_date,'DD The format string must be enclosed within single quotation marks. Passes the values that you want to convert to dates. is_date (INPUTSTRING, 'MM/DD/YYYY'), but it is returning some unpredictable results. The input is a string. You might use IS_DATE to test or filter data in a flat file before writing it to a target. TRUE (1) if the string is in a valid date format. If you are converting two-digit years with TO_DATE, use either the RR or YY format string. The output port for an IS_DATE expression must be String or Numeric datatype. The target column for an IS_DATE expression must be String or Numeric datatype. Pls note, Database doesnt store date in any format, its just date.
nglgsz
ewcdnowt
svlc
sbpf
ephv
vwch
avkydnwz
zxfequsd
tahc
jemc