cancel
Showing results for 
Search instead for 
Did you mean: 

How to customize the timestamp in JDBC to FILE scenario

Former Member
0 Kudos

Hi experts good evening.

In my JDBC to file scenario I want to add time stamp to my  file in YYYYMMDDHHMMSS in this format. I used Add timestamp option in file receiver communication channel. But It is generating in YYYYMMDD-HHMMSS-MS. But I don't want this format. Please help me on this.

Regards,

Anji Reddy

Accepted Solutions (1)

Accepted Solutions (1)

former_member184720
Active Contributor
0 Kudos

You should go for dynamic configuration UDF to set the filename dynamically.

Redirecting...

Please search for Dynamic filename UDF, you'll find lot of blogs on the same.

Answers (2)

Answers (2)

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Anji,

Please go for dynamic configuration mechanism and add the time stamp accordingly at mapping level.

Let me know if you want the udf code for it.

Regards

Vishnu

Former Member
0 Kudos

Thanks to all

I have done my scenario

Regards,

Anji Reddy

iaki_vila
Active Contributor
0 Kudos

Hi Anji,

Please follow the rules of the forum. Read this to close properly your thread. And please tell us what final solution you have done.

Regards.

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Anji,

As Inaki vila said, please close the thread discussion, which could help other fellow mates who will be having the same type of issue.

Regards

Vishnu

Former Member
0 Kudos

Hi,

Sorry iam new to this forum. Now I closed according to forum rules.

Regards,

Anji Reddy

iaki_vila
Active Contributor
0 Kudos

Hi Anji,

The fastest way is the way proposed by Hareesh. Also, you can do it with OS batch file or with an own module bean as Roger Allue explains and shares the code in his blog


Regards.