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

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download