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

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

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

TalendDate.getDate("MM-DD-CCYY")
Highlighted
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
Highlighted
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
Highlighted
One Star

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

Our Database(oracle) column format is Date(datatype)
Highlighted
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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog