topic Re: Convert from date to int in Talend Studio

Convert from date to int

Anonymous — Sat, 16 Nov 2024 04:49:33 GMT

Is there any way to implement this SQL method to convert date to int in Talend Open Studio?

convert(int, convert(varchar(10), mydate, 112))

Re: Convert from date to int

Anonymous — Thu, 29 Aug 2019 17:57:02 GMT

Can you give an example of input(s) and expected output(s)

Re: Convert from date to int

Anonymous — Thu, 29 Aug 2019 19:17:02 GMT

Input : 2018-12-19

Expected output : 20181219

Re: Convert from date to int

Anonymous — Thu, 29 Aug 2019 19:26:39 GMT

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date d = sdf.parse("2018-12-19");
sdf.applyPattern("yyyyMMdd");
String newDateString = sdf.format(d);   //20181219

Use SimpleDateFormat parse/format depending on input/output data type (i.e. String or Date)

Re: Convert from date to int

Anonymous — Thu, 29 Aug 2019 19:34:36 GMT

where should i write this code

can i convert the ouput to "int" type?

Re: Convert from date to int

Anonymous — Thu, 29 Aug 2019 19:44:20 GMT

Depends on the requirements, if you're parsing row by row, pass the input to a tJavaRow and put that code in making sure to pass the row value in and then out.

You can use Integer.parseInt() to convert string to int.

Re: Convert from date to int

Anonymous — Thu, 29 Aug 2019 19:49:24 GMT

Thank you soo much