Logstash date format











up vote
0
down vote

favorite












I am using logstash to parse json input message and then add another field from one of the parsed values:



filter {
json {
source => "message"
target => "data"
}
mutate {
add_field => {
"index_date" => "%{[data][@timestamp]}}"
}
}
}


This works fine, but now I need index_date to be only the date.
How can I format the [data][@timestamp] field to only return the date?










share|improve this question




























    up vote
    0
    down vote

    favorite












    I am using logstash to parse json input message and then add another field from one of the parsed values:



    filter {
    json {
    source => "message"
    target => "data"
    }
    mutate {
    add_field => {
    "index_date" => "%{[data][@timestamp]}}"
    }
    }
    }


    This works fine, but now I need index_date to be only the date.
    How can I format the [data][@timestamp] field to only return the date?










    share|improve this question


























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I am using logstash to parse json input message and then add another field from one of the parsed values:



      filter {
      json {
      source => "message"
      target => "data"
      }
      mutate {
      add_field => {
      "index_date" => "%{[data][@timestamp]}}"
      }
      }
      }


      This works fine, but now I need index_date to be only the date.
      How can I format the [data][@timestamp] field to only return the date?










      share|improve this question















      I am using logstash to parse json input message and then add another field from one of the parsed values:



      filter {
      json {
      source => "message"
      target => "data"
      }
      mutate {
      add_field => {
      "index_date" => "%{[data][@timestamp]}}"
      }
      }
      }


      This works fine, but now I need index_date to be only the date.
      How can I format the [data][@timestamp] field to only return the date?







      logstash






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 5 at 21:02









      Joel

      1,4765719




      1,4765719










      asked Nov 5 at 19:38









      javapenguin

      361823




      361823
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote



          accepted










          You will need to install the date_formatter plugin with



          bin/logstash-plugin install logstash-filter-date


          And then you can use something like this in your logstash filter function



          date_formatter {
          source => "index_data"
          target => "[@metadata][indexDateOnlyDate]"
          pattern => "YYYY.MM.dd"}


          This should work :)






          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














             

            draft saved


            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53161093%2flogstash-date-format%23new-answer', 'question_page');
            }
            );

            Post as a guest
































            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote



            accepted










            You will need to install the date_formatter plugin with



            bin/logstash-plugin install logstash-filter-date


            And then you can use something like this in your logstash filter function



            date_formatter {
            source => "index_data"
            target => "[@metadata][indexDateOnlyDate]"
            pattern => "YYYY.MM.dd"}


            This should work :)






            share|improve this answer

























              up vote
              0
              down vote



              accepted










              You will need to install the date_formatter plugin with



              bin/logstash-plugin install logstash-filter-date


              And then you can use something like this in your logstash filter function



              date_formatter {
              source => "index_data"
              target => "[@metadata][indexDateOnlyDate]"
              pattern => "YYYY.MM.dd"}


              This should work :)






              share|improve this answer























                up vote
                0
                down vote



                accepted







                up vote
                0
                down vote



                accepted






                You will need to install the date_formatter plugin with



                bin/logstash-plugin install logstash-filter-date


                And then you can use something like this in your logstash filter function



                date_formatter {
                source => "index_data"
                target => "[@metadata][indexDateOnlyDate]"
                pattern => "YYYY.MM.dd"}


                This should work :)






                share|improve this answer












                You will need to install the date_formatter plugin with



                bin/logstash-plugin install logstash-filter-date


                And then you can use something like this in your logstash filter function



                date_formatter {
                source => "index_data"
                target => "[@metadata][indexDateOnlyDate]"
                pattern => "YYYY.MM.dd"}


                This should work :)







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 6 at 16:28









                Robin Medland

                214




                214






























                     

                    draft saved


                    draft discarded



















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53161093%2flogstash-date-format%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest




















































































                    這個網誌中的熱門文章

                    Hercules Kyvelos

                    Tangent Lines Diagram Along Smooth Curve

                    Yusuf al-Mu'taman ibn Hud