Professional Web Applications Themes

how to get 3 or more connected dates - MySQL

PHP Version 4.3.10 MySQL: 4.1.10a Let's say I have a table "Delivery" with a column 'Date'. I had delivery's on 2007-05-01, 2007-05-02, 2007-05-08, 2007-05-15, 2007-05-16, 2007-05-17, 2007-05-30 How can I get all deliveries which: differ 1 day from each other and where there are 3 connected deliveries. In this example it would result in 2007-05-15, 2007-05-16, 2007-05-17...

  1. #1

    Default how to get 3 or more connected dates

    PHP Version 4.3.10
    MySQL: 4.1.10a

    Let's say I have a table "Delivery" with a column 'Date'.
    I had delivery's on 2007-05-01, 2007-05-02, 2007-05-08, 2007-05-15,
    2007-05-16, 2007-05-17, 2007-05-30

    How can I get all deliveries which:
    differ 1 day from each other and where there are 3 connected
    deliveries.

    In this example it would result in
    2007-05-15, 2007-05-16, 2007-05-17

    cvschie@gmail.com Guest

  2. #2

    Default Re: how to get 3 or more connected dates

    On 22 May, 13:19, com wrote: 

    What makes a delivery "connected"?

    Captain Guest

  3. #3

    Default Re: how to get 3 or more connected dates

    com wrote: 
    J.O.Aho just answered this question:

    One of the following should do what you need:

    PERIOD_ADD(P,N)
    ADDDATE(date,INTERVAL expr unit)
    ADDDATE(expr,days)

    http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_period-add

    use one of these in your predicate.

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

Similar Threads

  1. FTP connected ... but ...
    By JohnK in forum Linux / Unix Administration
    Replies: 18
    Last Post: September 27th, 11:48 PM
  2. Replies: 6
    Last Post: July 4th, 06:33 PM
  3. Connected movies
    By Cflp in forum Macromedia Director Basics
    Replies: 2
    Last Post: June 23rd, 04:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139