Can we generate BODS file with Time stamp (with milliseconds) ?

[Former Member]

Hi Gurus,

I'm able to generate a file in Data service with time stamp only till seconds.

But my requirement is to have milliseconds also added to it.

Currently the file generated is as below:

<Filename><yyyymmddhhmiss>.csv

<Filename><to_char(sysdate(),'yyyymmdd') ||to_char(sysdate(),'hhmiss')>

Can anyone please help how can I add milliseconds to it?

Best Regards,

Sandeep

[Former Member · Accepted solution]

Hi Sandeep,

Please try this,

to_char(sysdate(), 'YYYY-MM-DD-HH24.MI.SS.FF');

In your scenario it will be something like this. <Filename><to_char(sysdate(),'yyyymmdd') ||to_char(sysdate(),'hhmissff')>

Thanks,

Amit

[Former Member · Accepted solution]

Hi Amit,

Sorry for the delay in my reply.

I have tried your suggestion and it worked for me. Thank you.

Best Regards,

Sandeep