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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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