cannot parse a string to a date

Follow

Alicja Malota

• August 01, 2018 10:42

datameer.dap.common.exception.ComputationException: starttime1: =ASDATE(#starttime;"MM/dd/yy HH:mm:ss") failed with IllegalArgumentException: Cannot parse "3/29/2015 2:04": Illegal instant due to time zone offset transition (Europe/Madrid)

0

• 

  Konsta Danyliuk

  • August 01, 2018 12:37

  Hello Alicja.
  
  This error occurs because time stamp 3/29/2015 2:04 doesn't exist in the time zone Europe/Madrid. In 2015th Daylight Saving Time started in Spain on Sunday, 29 March 2015, at 02:00:00 clocks were turned forward 1 hour to Sunday, 29 March 2015, 03:00:00 local daylight time instead. Therefore 29 March 2015 02:04 has never happened.

  Please check our KB article How to Work with Datetime Values from Different Time Zones, it shows an example how to handle such cases.

  0

  Comment actions Permalink

Please sign in to leave a comment.