topic [Schema] Set default value for datetime in metadata schema in Talend Studio

[Schema] Set default value for datetime in metadata schema

Anonymous — Wed, 09 Sep 2015 10:27:34 GMT

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=en
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 ?

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

Anonymous — Wed, 09 Sep 2015 10:59:45 GMT

Hi,
I use this for the date:

TalendDate.formatDate("dd-MM-yyyy",TalendDate.getCurrentDate())

Regards
Burnside.

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

Anonymous — Wed, 09 Sep 2015 12:26:51 GMT

You used this in a tMap component ?