
Anonymous
Not applicable
2015-09-29
05:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
S'
Thanks.
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
Thanks.
602 Views
5 Replies

Anonymous
Not applicable
2015-09-29
11:42 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
TalendDate.getDate("MM-DD-CCYY")
602 Views

Anonymous
Not applicable
2015-09-30
10:44 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
ORA-01843: not a valid month when using the TalendDate.getDate("MM-DD-CCYY").Can you please suggest me
602 Views

Anonymous
Not applicable
2015-10-01
04:20 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it seems like ur database date format is not MM-DD-YYYY
602 Views

Anonymous
Not applicable
2015-10-02
11:05 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Our Database(oracle) column format is Date(datatype)
602 Views

Anonymous
Not applicable
2015-10-02
11:53 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ??
regards
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
602 Views
