javascript - Want to convert String data type into Date data type in pentaho - Stack Overflow

admin管理员组

文章数量:1345078

I have a string which has a date in this format: n_date=2014-04-20

I want to convert it into date data type

var Final_date = str2date(n_date,"yyyy-MM-dd");

but I get an error.

I'm do this in pentaho

I have a string which has a date in this format: n_date=2014-04-20

I want to convert it into date data type

var Final_date = str2date(n_date,"yyyy-MM-dd");

but I get an error.

I'm do this in pentaho

• javascript
• pentaho
• pentaho-data-integration

Share Improve this question Follow edited Jul 21, 2016 at 10:40 Ani Menon 28.3k1717 gold badges110110 silver badges127127 bronze badges asked Apr 28, 2015 at 6:01 MudiMudi 9511 gold badge22 silver badges1414 bronze badges 9

• Please post your error. – Bram Commented Apr 28, 2015 at 6:03
• Pentaho is in Java so I have to ask - Java or JavaScript? – jdphenix Commented Apr 28, 2015 at 6:08
• Could not apply the given format yyyy-MM-dd on the string for test value : Format.parseObject(String) failed (script#18) – Mudi Commented Apr 28, 2015 at 6:08
• – jdphenix Javascript – Mudi Commented Apr 28, 2015 at 6:09
• 1 is your question about Pentaho Data Integration (Kettle)? In which step you try to convert String to Date? Is it Modified JavaScript Value step? – mzy Commented Apr 28, 2015 at 11:29

 |  Show 4 more ments

1 Answer 1

Sorted by: Reset to default 7

You don't need a Java script step to do that. It's much easier and faster to use a calculator step or a select values step instead:

1) Calculator step: Create a new field, Final_date as a Copy of field A; on Field A put the name of your input string; Data type is date and on Conversion mask choose the yyyy-MM-dd format (you don't have to pick one from the dropdown menu, you can write your own);

2) Select values: on the Metadata panel, choose your input field and Date as the data type; as above, fill in the date format your data es in.

The difference between 1) and 2) is that in the 1st case you get a new field of the Date type, whereas in the 2nd case you change the data type of the input field.

本文标签： javascriptWant to convert String data type into Date data type in pentahoStack Overflow