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

One Star

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

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:MMSmiley FrustratedS'

Thanks.
One Star

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

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

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

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
One Star

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

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

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

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

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

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