Parsing error ( tib:parse-dateTime) with the date time 2012-03-29 02:00:00 .

Parsing error ( tib:parse-dateTime) with the date time 2012-03-29 02:00:00 .

book

Article ID: KB0091114

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
Description:
============
 
Parsing error ( tib:parse-dateTime) with the date time 2012-03-29 02:00:00
 
Sample Values:
 
2012-03-29 02:00:00
 
 
Environment:
===========
 
BW ALL
 
Symptoms:
========
 
The following exception  will be printed when mapper activity attempts to parse the following date time value.
tib:parse-dateTime('yyyyMMddHHmmss','20150329020000')

Exception:
Unparseable date: "20150329020000"

Cause:
=====
  This is caused by a Winter daylight saving in France. March 29th 2015 at 2am is the winter time change in France. So 2am does not exist and it will be become 3am.

Resolution:
==========
2012-03-29 02:00:00 AM should be treated as 2012-03-29 03:00:00 AM in France.

Issue/Introduction

Parsing error ( tib:parse-dateTime) with the date time 2012-03-29 02:00:00 .