topic TRUNC() FUNCTION in Talend Studio

TRUNC() FUNCTION

Anonymous — Sat, 16 Nov 2024 12:51:00 GMT

HIII...

i want to trunc() funtion on one of my columns in TMAP how do i call a routine on my col...
i mean is their any system routine which could handle this function........

Thanx in advance...
looking forward for a quick reply......

Re: TRUNC() FUNCTION

Anonymous — Wed, 22 Jun 2011 08:15:30 GMT

Hi
Do you want to use this function handle Date or numeric data? Can you give us an example to explain your request?
Best regards
Shong

Re: TRUNC() FUNCTION

Anonymous — Wed, 22 Jun 2011 09:31:32 GMT

yes.... its to handle a date...

its like i have column which contains date and time i want only date not time and round it... (as trunc does it)

DD-Mon-YYYY HH:MI S is the format i want it to be dd-mm-yyyy

regards

Re: TRUNC() FUNCTION

alevy — Thu, 23 Jun 2011 00:54:15 GMT

I asked https://community.talend.com/t5/Archive/SCD-ways-of-loading-a-fact-and-dimensional-table-at-the-same/td-p/175848 for such a method to be added to TalendDate, which was supposed to be in v4.2.0, but it hasn't been done yet .

Re: TRUNC() FUNCTION

Anonymous — Thu, 23 Jun 2011 06:00:08 GMT

Hi,
The problem is after truncating the date ,using Format or SimpleDateFormat in java,returning that date make again concatination of 00:00:00.The above java code is returning string,in date case we required string to date conversion again........
The code mention below returns the date but with concatination of 00:00:00 by itself....

public Date returnDate(Date dateTime)
{
SimpleDateFormat simpleDateFormat=new SimpleDateFormat("dd/MM/yyyy");

Format formatter=new SimpleDateFormat("dd/MM/yyyy");
String sample=formatter.format(dateTime);
try{
Date d=simpleDateFormat.parse(sample);
return d; //return date againwith hh:mm:ss concatination ,so no use of this function
}
catch (Exception e) {
e.printStackTrace();
}
return null;//as it is successful it will not return null ,it return d

}

Re: TRUNC() FUNCTION

Anonymous — Thu, 23 Jun 2011 09:38:09 GMT

Any help in regard to this forum will be appreciated

ThanQ

Re: TRUNC() FUNCTION

alevy — Fri, 24 Jun 2011 06:28:22 GMT

If you want a Date object as your output but with the time set to midnight, you can do it yourself with TalendDate.parseDate("dd/MM/yyyy",TalendDate.formatDate("dd/MM/yyyy",row1.newColumn)).
If you want a String object, you only need TalendDate.formatDate("dd-MM-yyyy",row1.newColumn).
And if you only want to output your Date to a file in the right format, just set the Date Pattern of the output schema to "dd-MM-yyyy".