How to select items whose expiry date match with the current date and find the difference between them











up vote
0
down vote

favorite












I have created a table ProductsTable with the following columns:



ProductID, ProductName, ExpiryDate


Now I want to select those products from the table whose expiry date is less than 90 days using a query. I am using Microsoft SQL Server.



Can anyone give me a guide?



Thanks in advance






c# sql-server







share|improve this question




















  • 1




    Did you already look at the DATEDIFF function? docs.microsoft.com/en-us/sql/t-sql/functions/…
    – Klaus Gütter
    Nov 11 at 7:45








  • 1




    Sample data is best served as DDL + DML. Please edit your question to include it, your current attempt and your desired results. For more details, read this.
    – Zohar Peled
    Nov 11 at 7:46










  • @KlausGütter your link is in German, in case you haven't noticed
    – roozbeh S
    Nov 11 at 7:48















up vote
0
down vote

favorite












I have created a table ProductsTable with the following columns:



ProductID, ProductName, ExpiryDate


Now I want to select those products from the table whose expiry date is less than 90 days using a query. I am using Microsoft SQL Server.



Can anyone give me a guide?



Thanks in advance






c# sql-server







share|improve this question




















  • 1




    Did you already look at the DATEDIFF function? docs.microsoft.com/en-us/sql/t-sql/functions/…
    – Klaus Gütter
    Nov 11 at 7:45








  • 1




    Sample data is best served as DDL + DML. Please edit your question to include it, your current attempt and your desired results. For more details, read this.
    – Zohar Peled
    Nov 11 at 7:46










  • @KlausGütter your link is in German, in case you haven't noticed
    – roozbeh S
    Nov 11 at 7:48













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I have created a table ProductsTable with the following columns:



ProductID, ProductName, ExpiryDate


Now I want to select those products from the table whose expiry date is less than 90 days using a query. I am using Microsoft SQL Server.



Can anyone give me a guide?



Thanks in advance






c# sql-server







share|improve this question















I have created a table ProductsTable with the following columns:



ProductID, ProductName, ExpiryDate


Now I want to select those products from the table whose expiry date is less than 90 days using a query. I am using Microsoft SQL Server.



Can anyone give me a guide?



Thanks in advance






c# sql-server




c# sql-server






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 11 at 8:49









marc_s

567k12610941246




567k12610941246










asked Nov 11 at 7:42









Xeroseven

15




15








  • 1




    Did you already look at the DATEDIFF function? docs.microsoft.com/en-us/sql/t-sql/functions/…
    – Klaus Gütter
    Nov 11 at 7:45








  • 1




    Sample data is best served as DDL + DML. Please edit your question to include it, your current attempt and your desired results. For more details, read this.
    – Zohar Peled
    Nov 11 at 7:46










  • @KlausGütter your link is in German, in case you haven't noticed
    – roozbeh S
    Nov 11 at 7:48














  • 1




    Did you already look at the DATEDIFF function? docs.microsoft.com/en-us/sql/t-sql/functions/…
    – Klaus Gütter
    Nov 11 at 7:45








  • 1




    Sample data is best served as DDL + DML. Please edit your question to include it, your current attempt and your desired results. For more details, read this.
    – Zohar Peled
    Nov 11 at 7:46










  • @KlausGütter your link is in German, in case you haven't noticed
    – roozbeh S
    Nov 11 at 7:48








1




1




Did you already look at the DATEDIFF function? docs.microsoft.com/en-us/sql/t-sql/functions/…
– Klaus Gütter
Nov 11 at 7:45






Did you already look at the DATEDIFF function? docs.microsoft.com/en-us/sql/t-sql/functions/…
– Klaus Gütter
Nov 11 at 7:45






1




1




Sample data is best served as DDL + DML. Please edit your question to include it, your current attempt and your desired results. For more details, read this.
– Zohar Peled
Nov 11 at 7:46




Sample data is best served as DDL + DML. Please edit your question to include it, your current attempt and your desired results. For more details, read this.
– Zohar Peled
Nov 11 at 7:46












@KlausGütter your link is in German, in case you haven't noticed
– roozbeh S
Nov 11 at 7:48




@KlausGütter your link is in German, in case you haven't noticed
– roozbeh S
Nov 11 at 7:48












1 Answer
1






active

oldest

votes

















up vote
0
down vote



accepted










Try this:



SELECT * FROM ProductsTable WHERE DATEDIFF(day,ExpiryDate,GETDATE()) < 90





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%2f53246773%2fhow-to-select-items-whose-expiry-date-match-with-the-current-date-and-find-the-d%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    0
    down vote



    accepted










    Try this:



    SELECT * FROM ProductsTable WHERE DATEDIFF(day,ExpiryDate,GETDATE()) < 90





    share|improve this answer

























      up vote
      0
      down vote



      accepted










      Try this:



      SELECT * FROM ProductsTable WHERE DATEDIFF(day,ExpiryDate,GETDATE()) < 90





      share|improve this answer























        up vote
        0
        down vote



        accepted







        up vote
        0
        down vote



        accepted






        Try this:



        SELECT * FROM ProductsTable WHERE DATEDIFF(day,ExpiryDate,GETDATE()) < 90





        share|improve this answer












        Try this:



        SELECT * FROM ProductsTable WHERE DATEDIFF(day,ExpiryDate,GETDATE()) < 90






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 11 at 8:38









        Bodul

        898




        898






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246773%2fhow-to-select-items-whose-expiry-date-match-with-the-current-date-and-find-the-d%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            Coverage of Google Street View

            Image
            Coverage of Google Street View From Wikipedia, the free encyclopedia Jump to navigation Jump to search Countries and dependencies with:    mostly full coverage    partial coverage    full or partial coverage planned (official)    full or partial coverage planned (unofficial)    views of selected businesses and/or tourist attractions only    views of private businesses only    no current or planned coverage Google Street View was first introduced in the United States on May 25, 2007, and until November 26, 2008, featured camera icon markers, each representing at least one major city or area (such as a park), and usually the other nearby cities, towns, suburbs, and parks. Many areas that had coverage were represented by icons. Contents 1 Key additions 2 Timeline of introductions 2.1 2007 2.2 2008 2.3 2009 2.4 2010 2.5 2011 2.6 2012 2.7 2013 2.8 2014 2.9 20...
            Read more

            Full-time equivalent

            Image
            Full-time equivalent From Wikipedia, the free encyclopedia Jump to navigation Jump to search Full-time equivalent ( FTE ) or whole time equivalent ( WTE ) is a unit that indicates the workload of an employed person (or student) in a way that makes workloads or class loads comparable [1] across various contexts. FTE is often used to measure a worker's or student's involvement in a project, or to track cost reductions in an organization. An FTE of 1.0 is equivalent to a full-time worker or student, while an FTE of 0.5 signals half of a full work or school load. [2] Contents 1 U.S. Federal Government 2 In education 2.1 Example 3 Notes 4 References U.S. Federal Government [ edit ] In the U.S. Federal Government, FTE is defined by the Government Accountability Office (GAO) as the number of total hours worked divided by the maximum number of compensable hours in a full-time schedule as...
            Read more

            Surfing

            Image
            Surfing From Wikipedia, the free encyclopedia Jump to navigation Jump to search This article is about stand-up ocean surfing. For other uses, see Surfing (disambiguation). "Surfer" redirects here. For other uses, see Surfer (disambiguation). Surfing A surfer at the Cayucos Pier, Cayucos, California Highest governing body World Surf League (WSL) Characteristics Mixed gender Yes, separate competitions Presence Country or region Worldwide Olympic Will debut in 2020 Surfing on the Gold Coast, Queensland, Australia Surfing is a surface water sport in which the wave rider, referred to as a surfer, rides on the forward or deep face of a moving wave, which usually carries the surfer towards the shore. Waves suitable for surfing are primarily found in the ocean, but can also be found in lakes or rivers in the form of a standing wave or tidal bore. However, surfers can also utilize artifi...
            Read more