str2date "01-JAN-2015"

yichuansancun

• May 04, 2015 00:00

• Answered

Follow

Hello -

How can I convert the string to date with the source format being "01-JAN-2015"?

I tried "dd-mm-yyyy" and "dd-mmm-yyyy" but no luck,

Perri

• 

  simaj

  • May 06, 2015 07:05

  0

  Comment actions Permalink

  Hi Perri,
  
  The Month has to be in capitals :
  
  

  
  	$out.0.field1=str2date($in.0.field1, "dd-MMM-yyyy");
  

  
  
  I hope this helps.
• 

  dpavlis

  • May 06, 2015 22:34

  0

  Comment actions Permalink

  More information on date & time format patterns is available in CloverETL User's Guide.

Please sign in to leave a comment.