topic Re: How to convert date format to integer? in Talend Studio

How to convert date format to integer?

rp2018 — Sat, 16 Nov 2024 07:28:48 GMT

Have a source field as 2018-10-10 as a date datatype. Would like to convert to 20181010, but it should be integer datatype. How can we achieve this by using tJavaRow?

Re: How to convert date format to integer?

Anonymous — Thu, 11 Oct 2018 17:58:10 GMT

Be aware that if your date is Stored as a Date, it will hold the complete date down to milliseconds. The code below shows converting from a String format (not required here, but I needed to do this to demonstrate how to do what you want) to a Date, and from a Date to an int.

//Set my date as a String
String date = "2018-10-10"; 
//Create my Date - Not necessary for you
Date myDate = routines.TalendDate.parseDate("yyyy-MM-dd", date);

//Convert my Date to an int
int myInt = Integer.parseInt(routines.TalendDate.formatDate("yyyyMMdd", myDate));

//Print out my int to prove it is correct
System.out.println(myInt);

Re: How to convert date format to integer?

rp2018 — Thu, 11 Oct 2018 20:32:58 GMT

The above commands worked fine when using tJavaRow and running the job. But when I connect tJavaRow to tMSSqlOutput, I can't seem to sync the columns. It puts the original source column instead of the column defined after converting it to int in tJavaRow. What should I do to sync it?

Re: How to convert date format to integer?

Anonymous — Thu, 11 Oct 2018 21:35:00 GMT

You need to match the tMSSqlOutput schema with your tJavaRow output schema. Alternatively put a tMap between your tJavaRow and your tMSSqlOutput component. That will make it easier for you to connect your columns appropriately.