Date Comparison Help

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Brian C. Doyle
    #1

    Date Comparison Help


    Hello all,

    I am rather confident that this has been answered in the past but searching
    for it has been a pain so I am asking for some assistance.

    I need a query to get data that is 6 months older than "today" or when that
    query is run.

    So the where clause is something like

    WHERE table.date >= now() - 6 months

    I know that will not work so how should I do this?



    ----------

    UMPA
    Brian C. Doyle
    Director, Internet Services
    United Merchant Processing Association
    <http://www.umpa-us.com>http://www.umpa-us.com
    1-800-555-9665 ext 212

    Tags: None
    • Mike Nolan
      #2
      Re: Date Comparison Help

      > I need a query to get data that is 6 months older than "today" or when that[color=blue]
      > query is run.[/color]

      WHERE table.date < current_date-interval'6 months'
      --
      Mike Nolan

      ---------------------------(end of broadcast)---------------------------
      TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

        Comment

        • Jim Seymour
          #3
          Re: Date Comparison Help

          "Brian C. Doyle" <bdoyle@umpa-us.com> wrote:[color=blue]
          >
          >
          > Hello all,
          >
          > I am rather confident that this has been answered in the past but searching
          > for it has been a pain so I am asking for some assistance.
          >
          > I need a query to get data that is 6 months older than "today" or when that
          > query is run.
          >
          > So the where clause is something like
          >
          > WHERE table.date >= now() - 6 months
          >
          > I know that will not work so how should I do this?[/color]

          WHERE age(table.date) > '6 months'

          --
          Jim Seymour | Spammers sue anti-spammers:
          jseymour@LinxNe t.com | http://www.LinxNet.com/misc/spam/slapp.php
          http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund:
          | http://www.spamcon.org/legalfund/

          ---------------------------(end of broadcast)---------------------------
          TIP 2: you can get off all lists at once with the unregister command
          (send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

            Comment

            • Brian C. Doyle
              #4
              Re: Date Comparison Help

              Perfect and thank you so much for the swift response;

              At 04:23 PM 4/8/2004, Mike Nolan wrote:[color=blue][color=green]
              > > I need a query to get data that is 6 months older than "today" or when[/color]
              > that[color=green]
              > > query is run.[/color]
              >
              >WHERE table.date < current_date-interval'6 months'
              >--
              >Mike Nolan[/color]



              ----------

              UMPA
              Brian C. Doyle
              Director, Internet Services
              United Merchant Processing Association
              <http://www.umpa-us.com>http://www.umpa-us.com
              1-800-555-9665 ext 212

                Comment

                Previous template Next
                Working...