Skip to Content
0

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

Jul 24, 2017 at 10:12 AM

50

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Jul 24, 2017 at 03:02 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

Sorry for the delay in my reply.

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

Best Regards,

Sandeep

0