topic Re: How to insert sysdate as (MM-DD-YYYY) in Talend tmap in Talend Studio

How to insert sysdate as (MM-DD-YYYY) in Talend tmap

Anonymous — Tue, 29 Sep 2015 21:36:37 GMT

Hello,
I'm new to Talend and trying to insert sysdate to the column tmap LOAD_TMTSMP in the output column expression which is the column that I did added which is not coming from the source.Can anyone please suggest me if their is a build date function in Talend to add the sysdate as (MM-DD-YYYY).
I'm using talenddate.getcurrentdate and where as it is inserting date as 'MM/DD/YYYY HH:MM S'

Thanks.

Re: How to insert sysdate as (MM-DD-YYYY) in Talend tmap

Anonymous — Wed, 30 Sep 2015 03:42:18 GMT

TalendDate.getDate("MM-DD-CCYY")

Re: How to insert sysdate as (MM-DD-YYYY) in Talend tmap

Anonymous — Wed, 30 Sep 2015 14:44:40 GMT

I'm getting an error ORA-01843: not a valid month
ORA-01843: not a valid month when using the TalendDate.getDate("MM-DD-CCYY").Can you please suggest me

Re: How to insert sysdate as (MM-DD-YYYY) in Talend tmap

Anonymous — Thu, 01 Oct 2015 08:20:43 GMT

it seems like ur database date format is not MM-DD-YYYY

Re: How to insert sysdate as (MM-DD-YYYY) in Talend tmap

Anonymous — Fri, 02 Oct 2015 15:05:53 GMT

Our Database(oracle) column format is Date(datatype)

Re: How to insert sysdate as (MM-DD-YYYY) in Talend tmap

Anonymous — Fri, 02 Oct 2015 15:53:53 GMT

hi all
Trace error telle us ORA-01843
http://www.dba-oracle.com/t_ora_01843_not_a_valid_month.htm
as j1122 has said , check pattern .
talend getDate method is to get a date in a certain format. what's about Date & Oracle ??

getDate : return the current datetime with the given display format format : (optional) string representing the
     * wished format of the date. This string contains fixed strings and variables related to the date. By default, the
     * format string is DD/MM/CCYY.

regards