topic Re: [resolved] Convert the BigDecimal Value into Date format in Talend Studio

[resolved] Convert the BigDecimal Value into Date format

Anonymous — Wed, 14 Aug 2013 08:15:43 GMT

Hi,
I am using Talend Data Integration Tool (5.3.1r104014), i would like to integrate the data from Source database to destination data base with using tmap_1 component, the source and destination are MSSQL.
So From the source data base they define the date format like this 20101109(i.e. data type is Bigdecimal), but in the destination the date format is dd/mm/yyyy (i.e. data type is date).
I am unable to convert the Bigdecimal value into Date format and unable to give the null value.
Code:
TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("yyyyMMdd",row1.newColumn.toString())))
When i am execute the above mentioned code in the Expression Builder, the result is "Exception in component tRowGenerator_1" appear.
And also i am unable to give the null date format like "12/31/1599" , Please find the attached screen shot.
Please help on the above two issues
Thanks in advance
Siva

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Wed, 14 Aug 2013 08:24:03 GMT

Hi,

When i am execute the above mentioned code in the Expression Builder, the result is "Exception in component tRowGenerator_1" appear.

The Test! button can't understand row2.AUDIT if the expression refers to a column value, you need to execute the job to see if the job works without any compilation error or Java error, we usually use the Test! button to test a function, as the screenshot showed.
Best regards
Sabrina

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Wed, 14 Aug 2013 10:32:50 GMT

Hi Sabrina,
Thank you for the information,
I would like to pass the null date like "12/31/1599", Is there any possibility to pass the null date,
Please let me know, what is the function to pass the null date value.
Thanks in Advance
Siva

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Wed, 14 Aug 2013 10:40:57 GMT

Hi,
Do you mean convert the null string or empty into 12/31/1599 by default?
Such as:
Input source:
12/04/2011;
null;
;
08/23/2012;
Expected result:
12/04/2011;
12/31/1599;
12/31/1599;
08/23/2012; ?
Best regards
Sabrina

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Wed, 14 Aug 2013 12:16:27 GMT

Hi,
When i give the input as 12/04/2011; i have faced the first screen error data type mismatch.
if i give the input null; the second screen shot error appear.
So what i am expected, i want a null date to pass the destination columns like 12/31/1599.
Please help us
Thanks
Siva

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Wed, 14 Aug 2013 14:14:00 GMT

Hi
According to your request, you need to convert null to a fixed date, before inserting it to target database, for example:
row1.newColumn==null?TalendDate.parseDate("MM/dd/yyyy", "12/31/1599"):TalendDate.parseDate("yyyyMMdd",row1.newColumn.toString())
And set the data type of this column as Date in the output table of tMap.
Shong

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Thu, 24 Oct 2013 14:45:46 GMT

Hello i'm when i'm convert unix date to readable date i got the default value for the timestamps date any help ?

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Fri, 25 Oct 2013 03:21:13 GMT

Hello i'm when i'm convert unix date to readable date i got the default value for the timestamps date any help ?

Take a look at a related topic:
https://community.talend.com/t5/Design-and-Development/resolved-Unix-date-to-normal-date-tmap/td-p/97297
If you still have problem, please describe your problem with more details.
Shong

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Thu, 08 Jan 2015 05:58:04 GMT

How to convert null into new BigDecimal?

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Wed, 21 Jan 2015 04:45:42 GMT

How to convert null into new BigDecimal?

Can you please explain your requirement with more details? Are you getting error when convert a column data to BigDecimal type?
Best regards
Shong

Re: [resolved] Convert the BigDecimal Value into Date format

Anonymous — Wed, 21 Jan 2015 04:50:28 GMT

This is now okay.
thank you