Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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:MM 0683p000009M9p6.pngS'

Thanks.
Labels (2)
5 Replies
Anonymous
Not applicable
Author

TalendDate.getDate("MM-DD-CCYY")
Anonymous
Not applicable
Author

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
Not applicable
Author

it seems like ur database date format is not MM-DD-YYYY
Anonymous
Not applicable
Author

Our Database(oracle) column format is Date(datatype)
Anonymous
Not applicable
Author

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