Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Weird conversion String to Date on offset location

  1. #1
    Join Date
    Jan 2018
    Posts
    22

    Default Weird conversion String to Date on offset location

    Hi everybody,
    I'm currently reading values from an XML input stream, and deserializing the data to match the correct data type.

    The problem I have comes from an error that I have deserializing one date in specific, below the error message:
    "couldn't convert string [25/03/2018 02:11:00] to a date using format [dd/MM/yyyy HH:mm:ss] on offset location 19".

    This looks pretty weird to me, since as far as I can see the format matches exactly the Date format in the XML file (<MY_DATE>25/03/2018 02:11:00</MY_DATE>).

    Anyone experienced it already?

    Many thanks!

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    Due to the change to summer time 02:11:00 is an incorrect time

  3. #3
    Join Date
    Jan 2018
    Posts
    22

    Default

    Thanks johanhammink for the reply.
    Actually, I don't understand why technically this is considered as incorrect, or specifically 'what' is considered incorrect, since the format itself doesn't change.

    Last but not least, how can I tell kettle to uniform the format for the whole year?

    Thanks again!

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    If your time change happened on Mar 25 at 2:00, then 02:11 wouldn't exist (Time goes 2018-03-25 01:59:59 -> 2018-03-25 03:00:00 )
    All your times have to be times that exist, or PDI can't process them.

  5. #5
    Join Date
    Jan 2018
    Posts
    22

    Default

    Now I see, even though I didn't think this could technically happen.
    Many thanks though!

  6. #6

    Default

    If you get this as a valid date, perhaps you should look into parsing dates without time zone info? Basically each time exists in GMT and any related time zone without Winter Time / Summer Time corrections.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.