Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Unable to parse date with this pattern MMM d, yyyy hh:mm:ss a z is it wrong?

  1. #1

    Default Unable to parse date with this pattern MMM d, yyyy hh:mm:ss a z is it wrong?

    I'm using Text file input object
    and trying to get from file this field as a date
    and all my tries are wrong

    Dec 22, 2010 12:04:07 PM GMT+01:00

    in the drop down doesn't appears this kind of date and I look into javadoc
    and try in this way

    MMM d, yyyy hh:mm:ss a z

    but it fails...see log please help me

    2011/02/01 13:32:24 - ghh input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) :
    2011/02/01 13:32:24 - ghh input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Scantime String(34) : couldn't convert string [Dec 22, 2010 12:04:07 PM GMT+01:00] to a date using format [MMM d, yyyy hh:mm:ss a z]
    2011/02/01 13:32:24 - bpower sware input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unparseable date: "Dec 22, 2010 12:04:07 PM GMT+01:00"

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    The regional settings in your system must be in English, so Kettle can recognize "Dec" as "December".

  3. #3

    Default

    I`ll try this thank you very much

  4. #4

    Default

    Quote Originally Posted by Maria Roldan View Post
    The regional settings in your system must be in English, so Kettle can recognize "Dec" as "December".
    It continues with the failure and I've changed my regional settings to English UK

  5. #5

    Default

    I did 2 changes and it works¡ date format locale en instead of es_ES
    and regional settings in windows 7 English , now it previews I'll try loading it
    thank you¡¡

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.