Date format question

David Paras

• December 08, 2014 17:38

Can somebody give me the format for the date below? This is the date in xml source file and I have to convert it to database ‘Datetime’ fotmat (i.e. ‘yyyy-mm-dd hh:mm:ss ) via mapping date function.

Date-format(‘2012-10-25T05:34:53.000-07:00’ ,????? , 'yyyy-MM-dd hh:mm:ss')

0

• 

  David Paras

  • December 08, 2014 17:38

  Try date-format( translate( '2012-10-25T05:34:53.000-07:00' , 'T' , ' ' ) ,'yyyy-MM-dd hh:mm s.S','yyyy-MM-dd hh:mm s'). This will remove the intermediary T and allow the date-format function to interpret the incoming value.

  0

Post is closed for comments.