Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed 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