topic Re: date format in talend in Talend Studio

date format in talend

Anonymous — Sat, 16 Nov 2024 14:11:44 GMT

Please let me know how to i make talend understand the date format of "2/21/2005 12:09:18 PM".
It says that it is unable to parse the date.

Re: date format in talend

Anonymous — Thu, 16 Oct 2008 18:45:44 GMT

What are you telling that date to?

for date format codes: http://java.sun.com/j2se/1.5.0/docs/api/java/text/SimpleDateFormat.html

Re: date format in talend

Anonymous — Thu, 16 Oct 2008 21:41:16 GMT

I am trying to convert the date format by using the function TalendDate.parseDate("MM/dd/yyyy hh:mm:ss",row1.START_DAY_ID ) in tmap.
But still it throughs the error Unparseable date: "2/21/2005 12:09:18 PM"

Re: date format in talend

Anonymous — Thu, 16 Oct 2008 22:10:38 GMT

1. is "2/21/2005 12:09:18 PM" coming in as a date or string value? (what type is row1.START_DAY_ID?)
2. "MM/dd/yyyy hh:mm:ss" should actually be "M/dd/yyyy hh:mm:ss" (only need 1 M and had 2 spaces between yyyy and hh)

Re: date format in talend

Anonymous — Thu, 16 Oct 2008 22:45:28 GMT

The data type of row1.START_DAY_ID is string.
I have reduced the extra space between yyyy and hh.
I get the error below when i use the function as TalendDate.parseDate("M/dd/yyyy hh:mm:ss",row1.START_DAY_ID )
Exception in component tDBOutput_1
java.sql.SQLException: Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(Unknown Source)

Re: date format in talend

Anonymous — Thu, 16 Oct 2008 23:21:41 GMT

interesting... that error I have no idea about.

Re: date format in talend

Anonymous — Wed, 13 Jul 2011 08:51:55 GMT

Hello,
I have a question,
Right now, I have to check whether the input string is in the format of "YYYYMMWW",(year month week)
so how can I parse this into another string?
is Talend.parseDate() helpful? if so how can I use this?
I've tried Talend.parseDate("yyyymmww",row1.weekstring).toString(), but it is not writing into the table as desired.
It has gone into the table in such format (Sun Apr 18 00:04:00 SGT 2010).
Please guide me how can I do.
Thanks.

Re: date format in talend

Anonymous — Wed, 13 Jul 2011 10:06:23 GMT

Hello,
I have a question,
Right now, I have to check whether the input string is in the format of "YYYYMMWW",(year month week)
so how can I parse this into another string?
is Talend.parseDate() helpful? if so how can I use this?
I've tried Talend.parseDate("yyyymmww",row1.weekstring).toString(), but it is not writing into the table as desired.
It has gone into the table in such format (Sun Apr 18 00:04:00 SGT 2010).
Please guide me how can I do.
Thanks.

Hi
I have replied you on 16769. I think you should use the built-in function TalendDate.isDate(String stringDate, String pattern).
Best regards
Shong

Re: date format in talend

Anonymous — Wed, 13 Jul 2011 10:20:26 GMT

Hi Shong,
Sorry my bad, I have left to write the main part,
I have to check the date format and compare it to the current date.

Re: date format in talend

Anonymous — Wed, 13 Jul 2011 10:25:26 GMT

Hi Shong,
Sorry my bad, I have left to write the main part,
I have to check the date format and compare it to the current date.

Ok, let's discuss your problem in your 16769.
Best regards
Shong

Re: date format in talend

Anonymous — Tue, 18 Mar 2014 11:17:30 GMT

svp comment generer des tables destinataires automatiquement depuis un traitement de la table source? merci d'avance

Re: date format in talend

Anonymous — Wed, 19 Mar 2014 06:53:01 GMT

Hi raouf12,
This is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!
Best regards
Sabrina

Re: date format in talend

Anonymous — Tue, 05 Jan 2016 15:55:21 GMT

Hello, How can I convert month name to number in talend. for example to January to 1, February to 2, March to 3 and so on.

Re: date format in talend

Anonymous — Wed, 06 Jan 2016 06:32:46 GMT

Hi avvirama,
Is your input month name source "Date" data type?
If so, please try to use the below expression in tMap
TalendDate.formatDate("yyyy-MM-dd",your date field);
Best regards
Sabrina