One Star

[Schema] Set default value for datetime in metadata schema

I see in this post that we can set a default date value to current date.
https://help.talend.com/search/all?query=Verifying+default+values+in+a+retrieved+schema&content-lang...
I try it but when my flow want to create an XML file with the tAdvancedFileOutputXML, an error occur as 'sysdate is not valid'.
I think that this sysdate is an Oracle value, not Talend.
Then, how can i set my default date value to current date in my metadata schema ? If can't, did i must set these default in my tMap ?
2 REPLIES
One Star

Re: [Schema] Set default value for datetime in metadata schema

Hi,
I use this for the date:
TalendDate.formatDate("dd-MM-yyyy",TalendDate.getCurrentDate())

Regards
Burnside.
One Star

Re: [Schema] Set default value for datetime in metadata schema

You used this in a tMap component ?