Service Virtualization

Expand all | Collapse all

Time Stamp filter

Jump to Best Answer
  • 1.  Time Stamp filter

    Posted 05-01-2018 01:07 PM
      |   view attached

    Hi All,

     

    When I set Time Stamp Filter format as 'YYYY-MMM-DD', I'm getting the resultant as '2018-May-121'.

    Why I'm always getting 21 at the end?

     

    Thanks,

    John



  • 2.  Re: Time Stamp filter
    Best Answer

    Posted 05-01-2018 01:30 PM

    Hi John,

     

    You're not getting an extraneous "21" - you're actually getting "121".  May 1st is day 121 of the year (yes, I had to look that up  ).

     

    Please use the Java documentation for SimpleDateFormat as a guide:

     

    https://docs.oracle.com/javase/8/docs/api/

     

    Capital "D" is for day of the year.  Lowercase "d" is for day of the month.  The uppercase "Y" might cause problems, too.

     

    Try: "yyyy-MMM-dd" for "2018-May-01" or "yyyy-MM-dd" for "2018-05-01".  There are other variations, too.

     

    --Mike



  • 3.  Re: Time Stamp filter

    Posted 05-01-2018 01:37 PM

    Yeahhhh... Thank you, Mike. Appreciate much!

    -John